:

RSSData Pump

ORA-39213: Metadata processing is not available

The Problem While using data pump in an Oracle 10g database, I got the following error: ORA-39006: internal error ORA-39213: Metadata processing is not available I read through a post on the Oracle forum and did what was suggested. I kicked off the job again and this time got a different error: ORA-39006: internal error ORA-39065: unexpected […]

Continue Reading

ORA-31623: a job is not attached to this session via the specified handle

ORA-31623: a job is not attached to this session via the specified handle

Oracle Version: 11.2.0.2 Patchset 10 Platform: Windows Server 2003 R2 The Problem I was attempting to execute a data pump import job which I had run numerous times before, but unfortunately this time around it didn’t seem to be working. I got the following error: ORA-31623: a job is not attached to this session via […]

Continue Reading

ORA-20005: object statistics are locked

When using data pump to import a set of tables and data into an Oracle 10.2.0.4 database I received the following error: ORA-20005: object statistics are locked (stattype = ALL) In order to fix the issue, I used DBMS_STATS.UNLOCK_TABLE_STATS on each table of interest before running the import command. The statement takes the arguments of […]

Continue Reading

Wait for unread message on broadcast channel

Wait for unread message on broadcast channel

When using data pump you will have a calling session which is the session that you log into the DB with when executing the impdp or expdb utility. Within the DB there will be one or more sessions which are called by this main data pump session; namely DWn. Where N is a number. I […]

Continue Reading