Database Administration (MOSC)

MOSC Banner

impdp- failing with ORA-39083: ORA-00955:

edited Aug 15, 2016 10:10PM in Database Administration (MOSC) 9 commentsAnswered

My import is failing with the below error. Can the below be ignored? What is this import queue table? can anyone share some light? I searched and am unlikely to get relevant documents.

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

ORA-00955: name is already used by an existing object

Failing sql is:

BEGIN

SYS.DBMS_AQ_IMP_INTERNAL.IMPORT_QUEUE_TABLE('LIST_AQ_TABLE',1,16392,3,0,0,'', SYS.DBMS_AQ_IMP_INTERNAL.DBVER_10i, '00:00');COMMIT; END;

     Completed 1 PROCACT_INSTANCE objects in 1 seconds

     Completed 8 TABLE_EXPORT/TABLE/TABLE_DATA objects in 11681 seconds

Job "DMT"."SYS_IMPORT_FULL_61" completed with 1 error(s) at Mon Aug 8 06:34:19 2016 elapsed 0 03:14:57

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