Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps

Friday, August 6, 2010

ORA-39083: Object type ROLE_GRANT failed to create with error:

I got this error when I was trying to do a full import of a dump file.

$ impdp "'/ as sysdba'" full=y directory=data_pump_dir dumpfile=fullexport.dmp logfile=fullimport.log

Import: Release 11.2.0.1.0 - Production on Sat Aug 7 01:02:52 2010

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYS"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_FULL_01": "/******** AS SYSDBA" full=y directory=data_pump_dir dumpfile=fullexport.dmp logfile=fullimport.log
Processing object type SCHEMA_EXPORT/ROLE_GRANT
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'QUALYS_ROLE' does not exist
Failing sql is:
GRANT "QUALYS_ROLE" TO "SYS" WITH ADMIN OPTION

Job "SYS"."SYS_IMPORT_FULL_01" completed with 1 error(s) at 01:03:06


I checked the dump file and it was only 141 KB in size. Then I checked the export log file and realized that I had forgotten to put full=y while doing expdp. So it was just a schema export of SYS and did not have the full database.

Once I realized this and took an export with expdp full=y command, the import completed successfully.

1 comment:

healy said...

thanks for sharing a good dose of facts. . .keep posted