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"
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.