While
doing export on my 12.1 database i get below error
oracledev.domain.com:REPODB:/home/oracle
$ expdp directory=STATSDIR dumpfile=REPODB_Triggers.dmp logfile=exp_REPODB_Triggers.log
include=TRIGGER metrics=y schemas= Workers
Export: Release 12.1.0.2.0 - Production on Wed Oct 23 10:48:44 2019
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
Username: / as sysdba
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
ORA-39001: invalid argument value
ORA-01775: looping chain of synonyms
FIX:
SQL> Select owner, object_name, object_type, status from dba_objects where object_name like '%SYS_EXPORT%';
OWNER
--------------------------------------------------------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE STATUS
----------------------- -------
PUBLIC
SYS_EXPORT_SCHEMA_01
SYNONYM VALID
SYSTEM
SYS_EXPORT_TABLE_01
TABLE VALID
connect / as sysdba
drop public synonym sys_export_schema_01;
Now rerun export again
(OR)
If you dont want to drop the table now then give some job name ( job_name=<JOB_NAME>" ) and run the export
Export: Release 12.1.0.2.0 - Production on Wed Oct 23 10:48:44 2019
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
Username: / as sysdba
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
ORA-39001: invalid argument value
ORA-01775: looping chain of synonyms
FIX:
SQL> Select owner, object_name, object_type, status from dba_objects where object_name like '%SYS_EXPORT%';
OWNER
--------------------------------------------------------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE STATUS
----------------------- -------
PUBLIC
SYS_EXPORT_SCHEMA_01
SYNONYM VALID
SYSTEM
SYS_EXPORT_TABLE_01
TABLE VALID
connect / as sysdba
drop public synonym sys_export_schema_01;
(OR)
If you dont want to drop the table now then give some job name ( job_name=<JOB_NAME>" ) and run the export
Referrence:
DataPump Import Results In ORA-39001 Invalid Argument Value ORA-1775 Looping Chain Of Synonyms (Doc ID 459151.1)
0 comments:
Post a Comment