Error While Impdp [message #478398] |
Fri, 08 October 2010 08:38 |
madhavamanohar
Messages: 58 Registered: February 2009
|
Member |
|
|
Dear TEam,
Getting below error While Impdp.. Please sugest
Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA
ORA-39083: Object type PROCACT_SCHEMA failed to create with error:
ORA-31625: Schema ADAS is needed to import this object, but is unaccessible
ORA-28031: maximum of 148 enabled roles exceeded
Failing sql is:
BEGIN
sys.dbms_logrep_imp.instantiate_schema(schema_name=>SYS_CONTEXT('USERENV','CURRENT_SCHEMA'), export_db_name=>RD''PCA, inst_scn=>'21502808296');COMMIT; END;
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-31671: Worker process DW01 had an unhandled exception.
ORA-01031: insufficient privileges
ORA-06512: at "SYS.KUPW$WORKER", line 13249
ORA-06512: at "SYS.KUPW$WORKER", line 14900
ORA-06512: at "SYS.KUPW$WORKER", line 6293
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS while calling KUPP$PROC.CHANGE_USER [PROCACT_SCHEMA:"ASIF"]
ORA-06512: at "SYS.KUPW$WORKER", line 12280
ORA-01031: insufficient privileges
ORA-06512: at "SYS.KUPW$WORKER", line 5288
ORA-39083: Object type PROCACT_SCHEMA failed to create with error:
ORA-31625: Schema XXXX is needed to import this object, but is unaccessible
ORA-28031: maximum of 148 enabled roles exceeded
Failing sql is:
BEGIN
sys.dbms_logrep_imp.instantiate_schema(schema_name=>SYS_CONTEXT('USERENV','CURRENT_SCHEMA'), export_db_name=>'', inst_scn=>'21502808296');COMMIT; END;
ORA-06512: at "SYS.KUPW$WORKER", line 1342
ORA-06512: at line 2
Job "SYS"."SYS_IMPORT_FULL_01" stopped due to fatal error at 17:13:38
Thanks IN Advance.
|
|
|
|
Re: Error While Impdp [message #478405 is a reply to message #478398] |
Fri, 08 October 2010 09:03 |
madhavamanohar
Messages: 58 Registered: February 2009
|
Member |
|
|
Thanks for you reply.
I am just importing..And I checked in Db..USER is having more than 148 roles..and I have revoked some roles ..Shall I proceed with import now.
Thanks
Mano
|
|
|