Tags: advice, database, datapump, error, expdp, greatly, mysql, ora-31623, oracle, provide, sql

expdp ORA-31623

On Database » Oracle

2,095 words with 1 Comments; publish: Thu, 14 Feb 2008 04:05:00 GMT; (25078.13, « »)

Anyone ever seen this or can provide any advice on how to deal with this datapump error? Any advice would be greatly appreciated.

Thanks,

Aaron

$ORACLE_HOME/bin/expdp dumpfile=edb_expdp.dmp directory=BACKUPAREA

schemas=edb userid=edb/edb

Export: Release 10.1.0.4.0 - 64bit Production on Tuesday, 20 March, 2007 10:56

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

UDE-00008: operation generated ORACLE error 31623

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

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

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

ORA-06512: at line 1

All Comments

Leave a comment...

  • 1 Comments
    • This issue was resolved with the help of Oracle Support...the fix is below.

      29-MAR-07 15:18:20 GMT

      The error ORA-980 refers to synonyms. The spooled output file source.out shows a synonym PUBLIC.SYS_EXPORT_SCHEMA_02 which is unusual. The sql trace file shows the name for the master table: SYS_EXPORT_SCHEMA_01 and an error for the cursor: SELECT COUNT(*) FROM SYS_EXPORT_SCHEMA_0

      This could indicate that there are synonyms active...

      Please Run and upload the result of the following Query .

      col owner.synonym_name for a40

      col table_owner.table_name for a35

      select owner||'.'||synonym_name "OWNER.SYNONYM_NAME",

      table_owner||'.'||table_name "TABLE_OWNER.TABLE_NAME"

      from dba_synonyms

      where (synonym_name in ('SYS','SYSTEM','DUAL') or table_name = 'DUAL')

      or synonym_name like 'SYS_EXPORT%';

      query result:

      PUBLIC.SYS_EXPORT_SCHEMA_01 EDB.SYS_EXPORT_SCHEMA_01

      PUBLIC.SYS_EXPORT_SCHEMA_02 EDB.SYS_EXPORT_SCHEMA_02

      PUBLIC.SYS_EXPORT_SCHEMA_03 EDB.SYS_EXPORT_SCHEMA_03

      The tables energydb.sys_Export_schema* do not exist. I dropped the three public synonyms and reran the expdp. This expdp ran successfully.

      Message was edited by:

      abett_dba

      #1; Sat, 23 Feb 2008 17:03:00 GMT