My Oracle Support Banner

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
...

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.