Return
-
Title
Data Pump Export Wizard/Import Wizard Duplicates Privileges and causes ORA-39083 errorr -
Description
When using the Data Pump Export Wizard to export a schema and then import that schema into another database, I get multiple ORA-39083 errors because the object grants are being duplicated. Notice all the UPDATEs below.
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01711: duplicate privilege listed
Failing sql is:
GRANT SELECT, UPDATE, UPDATE, UPDATE, UPDATE, UPDATE, UPDATE, UPDATE, UPDATE, UPDATE, UPDATE, UPDATE, UPDATE, UPDATE, UPDATE ("FDTMWITHRGSTRTNCMPLTDT") ON "RTDB"."V_TBLGA_DWFORCEDREGISTRATIONS" TO "GTINT_ROLE"
-
Cause
It appears to be caused when permissions have been granted at the column level rather than the table level, e.g. GRANT DELETE, SELECT, UPDATE ("FSTRERROR") ON "RTDB"."V_TBLGA_CMS" TO "GTINT_ROLE"
-
Resolution
This is an issue with Oracle's Data Pump Export and Import feature. If you trying running Data Pump through the command line, instead of using Toad, the same error occurs. You will want to contact Oracle about the issue.