0

I was trying to import a dump file using IMPDP command and has end up with the following errors:

ORA-31626: job does not exist
ORA-31637: cannot create job SYS_IMPORT_FULL_01 for user user1
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 798
ORA-39244: Event to disable dropping null bit image header during relational select
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPC$QUE_INT", line 1825
ORA-04063: package body "SYS.DBMS_AQADM_SYS" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_AQADM_SYS"

I have searched on oracle forums and google for any solution. Not sure why this error is happening. Is this related to the db configuration?

closed as unclear what you're asking by Paul White, Colin 't Hart, RolandoMySQLDBA, RLF, Mark Storey-Smith May 3 '15 at 11:54

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • Which user are you trying to import as? Also, OS and Oracle DB version are helpful. – captjackvane Dec 5 '14 at 21:13
1

For me this line seems most telling:

PL/SQL: could not find program unit being called: "SYS.DBMS_AQADM_SYS"

You should check to see if the user that you exported had a job scheduled using a program owned by someone else. If so you are trying to schedule a job for a program that does not exist. You can create the program, then do the import as long as the user who will own the program exists before you create the program as that user.

  • Thanks for the effort. But the issue get resolved when I re-installed the database. Don't know what was the issue. – NaaN Dec 9 '14 at 4:06

Not the answer you're looking for? Browse other questions tagged or ask your own question.