Anyone ever seen this or can provide any advice on how to deal with this datapump error? Any advice would be greatly appreciated.
$ORACLE_HOME/bin/expdp dumpfile=edb_expdp.dmp directory=BACKUPAREA
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
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",
where (synonym_name in ('SYS','SYSTEM','DUAL') or table_name = 'DUAL')
or synonym_name like 'SYS_EXPORT%';
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