Maclean Liu(刘相兵

ODM FINDING:

        Errors ORA-31626 ORA-31637 ORA-06512 ORA-39080 ORA-1403 Received When Using DataPump Export (Doc ID 744700.1)       

There are several solutions to this issue.  To implement the solution, please execute one of the following steps:

1. Upgrade to the 10.2.0.4 or 11.1.0.6 or higher releases:

Or:

2. If available for your platform, download and install Patch 4478139 and then reload the data pump types and views as outlined in Note:430221.1

connect as SYS then run the following:

SQL >@ $ORACLE_HOME\rdbms\admin\catdph.sql
Note: If XDB is installed, then it is required to run "catmetx.sql" script also.
Use this code to verify if XDB is installed:

SQL> select substr(comp_name,1,30) comp_name, substr(comp_id,1,10) comp_id,substr(version,1,12) version,status
from dba_registry;

Sample output if XDB installed,
     Oracle XML Database XDB -version- VALID

SQL >@ $ORACLE_HOME\rdbms\admin\prvtdtde.plb
SQL >@ $ORACLE_HOME\rdbms\admin\catdpb.sql
SQL >@ $ORACLE_HOME\rdbms\admin\dbmspump.sql

Or:

3. Use the workaround:

As the SYSDBA user

Shutdown database
Start the database in the UPGRADE mode
Drop the excess SYS roles:
drop role <role name>;
Reload the data pump types and views as outlined in Note:430221.1:
connect as SYS then run the following:

SQL >@ $ORACLE_HOME\rdbms\admin\catdph.sql
Note: If XDB is installed, then it is required to run "catmetx.sql" script also.
Use this code to verify if XDB is installed:

SQL> select substr(comp_name,1,30) comp_name, substr(comp_id,1,10) comp_id,substr(version,1,12) version,status
from dba_registry;

Sample output if XDB installed,
     Oracle XML Database XDB -version- VALID

SQL >@ $ORACLE_HOME\rdbms\admin\prvtdtde.plb
SQL >@ $ORACLE_HOME\rdbms\admin\catdpb.sql
SQL >@ $ORACLE_HOME\rdbms\admin\dbmspump.sql

Shutdown/startup