While running expdp, export fails to start with the following error :
ORA-39038: Object path "TABLE" is not supported for SCHEMA jobs
or
ORA-39038: Object path "SCHEMA" is not supported for FULL jobs
To get the name of the table/schema that needs to be exported to get populated, run the following scripts via SQL*Plus
SQL> connect / as sysdba
SQL> @$ORACLE_HOME/rdbms/admin/catmet2.sql
SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql
Then verify with:
SQL> SELECT named, object_path, comments FROM schema_export_objects WHERE named='Y';
if the entries are there and if they are present, then retry with expdp
expdp runs fine after running above sqls.
No comments:
Post a Comment