Error ORA-39127 When Using DataPump Export (EXPDP)
Last updated on NOVEMBER 28, 2016
Applies to:
Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.2.0.3 [Release 10.1 to 11.2]Information in this document applies to any platform.
***Checked for relevance on 26-May-2014***
Symptoms
You performed a full database export using the DataPump export utility (EXPDP) with these parameters:
#> expdp system/passwd full=y directory=dpu dumpfile=full.dmp include=(index,grant,constraint) logfile=full.log
This ended with errors like:
...
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/GRANT/CROSS_SCHEMA/OBJECT_GRANT
ORA-39127 : unexpected error from call to export_string := SYS.DBMS_RMGR_GROUP_EXPORT.grant_exp(3729,1,...)
ORA-06502 : PL/SQL: numeric or value error: NULL index table key value
ORA-06512 : at "SYS.DBMS_RMGR_GROUP_EXPORT", line 130
ORA-06512 : at line 1
ORA-06512 : at "SYS.DBMS_METADATA", line 5111
...
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/GRANT/CROSS_SCHEMA/OBJECT_GRANT
ORA-39127 : unexpected error from call to export_string := SYS.DBMS_RMGR_GROUP_EXPORT.grant_exp(3729,1,...)
ORA-06502 : PL/SQL: numeric or value error: NULL index table key value
ORA-06512 : at "SYS.DBMS_RMGR_GROUP_EXPORT", line 130
ORA-06512 : at line 1
ORA-06512 : at "SYS.DBMS_METADATA", line 5111
...
Cause
Sign In with your My Oracle Support account |
|
Don't have a My Oracle Support account? Click to get started |
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms