Hi, I recently got .dmp file that had a lot of tables that needed filtering. I wasn't able to import it correctly using DBSM_DATAPUMP.METADATA_FILTER filtering it with NAME_LIST or INCLUDE_PATH_LIST since nothing was getting imported mentioned in the documentation.
But looking at the DBMS_METADATA API, found that there is a method called EXCLUDE_NAME_EXPR.
On my end I wrote the filter as:
DBMS_DATAPUMP.METADATA_FILTER (handle => hdnl, name =>'INCLUDE_NAME_LIST', value => '''HR'',''SALES''', object_type => 'TABLE');
After that, I was able to import the schema with only the tables above (HR and SALES).
There is no mentioning of 'INCLUDE_NAME_LIST' or 'INCLUDE_NAME_EXPR' as options in the DBSM_DATAPUMP.METADATA_FILTER().
Is that method missing from the documentation?
Just wanted to share my case scenario if someone is on a similar situation.