Database Administration (MOSC)

MOSC Banner

EXPDP/IMPDP errors at schema level

edited Feb 4, 2013 4:25AM in Database Administration (MOSC) 5 commentsAnswered
Hello All,
My team mate was  trying to impdp and getting the below errors for one of the schema's. Could you please let me know does it has any work around for the below issue.

Db -- two node RAC of 11.2.0.3 db . last PSU applied in July-12

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM
ORA-39097: Data Pump job encountered unexpected error -12801
ORA-39065: unexpected master process exception in MAIN
ORA-12801: error signaled in parallel query server PZ99, instance
ORA-46010: unimplemented or unreasonable conversion requested

Initial research says ..

DataPump Import Fails With Errors ORA-39097 ORA-39065 ORA-12801 ORA-1460 [ID 1485879.1]

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center