This content has been marked as final. Show 10 replies
could be syntax issue,post your cmd with parfile.
31655, 00000, "no data or metadata objects selected for job"
// *Cause: After the job parameters and filters were applied,
// the job specified by the user did not reference any objects.
// *Action: Verify that the mode of the job specified objects to be moved.
// For command line clients, verify that the INCLUDE, EXCLUDE and
// CONTENT parameters were correctly set. For DBMS_DATAPUMP API
// users, verify that the metadata filters, data filters, and
// parameters that were supplied on the job were correctly set.
command used expdp parfile=parfile.
tables="select wm_concat(table_name) from user_tables where table_name like '%CPAY%'" userid=archive/v3rs1on DIRECTORY=data_exports_dir DUMPFILE=por_archive.dmp LOGFILE=por_exp.log PARALLEL=16 CONTENT=DATA_ONLY
expdp works fine when use tables as list e.g tables=table1,table2
just when try make table list name dynamic
the tables= parameter takes a list, not a query, however, you could run a schema mode export and use the include parameter, which in this case, is the same as running the table mode export:
expdp user/password schemas=schema_foo include=tables:'IN ((SELECT TABLE_NAME FROM MY_TABLE_CONTAINING_NAMES))'
It is best to put the include parameter into a parameter file so you don't have to worry about extra quoting and escaping.