Tuesday, July 21, 2009

ORA-39038 while running expdp

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: