Hi There
I am not sure if this is the right category - but I will post in any case.
I have spent the entire morning trying to exclude ONE table from my automated logical backups. It happens to hold 90% of the data (documents) so I want a shorter non blob export to run more frequently.
Here is the relevent section from the proc for the batch job.
It is V19 std ed 2 on OCI.
h1 := dbms_datapump.open('EXPORT','SCHEMA');
dbms_datapump.add_file(h1, 'fdd-' || l_postfix || '.dmp', p_directory, NULL, DBMS_DATAPUMP.KU$_FILE_TYPE_DUMP_FILE, 1); -- 1 indicates overwrite file if it exists ...
dbms_datapump.add_file(h1, 'fdd-' || l_postfix || '.log', p_directory, NULL, DBMS_DATAPUMP.KU$_FILE_TYPE_LOG_FILE, 1);
-- dbms_datapump.metadata_filter(handle => h1, name=>'SCHEMA_EXPR', value => 'IN (''' || p_schema_name || ''')');
-- Try hardcoding
dbms_datapump.metadata_filter(handle => h1, name=>'SCHEMA_EXPR', value => 'IN (''PROD'')');
dbms_datapump.metadata_filter(handle => h1, name=>'NAME_EXPR', value => ' <> ''CDD_BLOBS''');
dbms_datapump.set_parameter(h1,'CLIENT_COMMAND','Schema dp export, no blobs');
dbms_datapump.start_job(h1);
dbms_datapump.detach(h1);
I have tried endless valiations on the NAME_EXPR and done searches and used several I agents but cannot get it to work.
I am getting:
*
ERROR at line 1:
ORA-39001: invalid argument value
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4929
ORA-06512: at "SYS.DBMS_DATAPUMP", line 6378
ORA-06512: at "FIRSTDDPROD.FDD_BATCH", line 142
ORA-06512: at line 1
Line 142:
dbms_datapump.metadata_filter(handle => h1, name=>'NAME_EXPR', value => ' <> ''CDD_BLOBS''');
The requirement is simple - exclude one table.
I would really appreciate any help - or confirmation that this is not available in Standard ed.
Thank you
Paul