Error ORA-39127 When Using DataPump Export (EXPDP)
(Doc ID 451987.1)
Last updated on AUGUST 19, 2020
Applies to:
Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.2.0.3 [Release 10.1 to 11.2]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
You performed a full database export using the DataPump export utility (EXPDP) with these parameters:
#> expdp system/passwd full=y directory=<DIRECTORY_NAME> dumpfile=<DUMP_NAME>.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
...
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |