Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Not able to use expdp/impdp utility in oracle11g

PACHAURI ABHISHEKMar 26 2014 — edited Mar 27 2014

While trying to export the user objects using expdp getting the following error

via the specified handle

ORA-06512: at "SYS.DBMS_DATAPUMP", line 3263

ORA-06512: at "SYS.DBMS_DATAPUMP", line 4488

ORA-06512: at line 1

Everything was working fine until yesterday. I had initiated a impdp and it got stuck in between, hence I had no option other than pressing CTRL+C

Since then, I am not able to use either expdp or impdp

There are no entries available in dba_datapump_jobs, also in the dba_registry, the object states are showing as valid.and there are no invalid objects available in dba_objects which are owned by SYS user.

Any help would be appreciated..

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 24 2014

Added on Mar 26 2014

#database-key-features, #export-import-sql-loader-external-tables

16 comments

1,162 views