Oracle Database
--
Questions
--
Followers
Top Experts
ORA-01775: looping chain of synonyms
I'm trying to put together a Data Pump Export but I get the following error message:
[oracle@oratest oracle]$ ./datapump.sh
Export: Release 10.2.0.2.0 - Production on Monday, 25 June, 2007 14:51:11
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Release 10.2.0.2.0 - Production
ORA-39001: invalid argument value
ORA-01775: looping chain of synonyms
[oracle@oratest oracle]$
--------------------------
This is my data pump script:
#!/bin/sh
/oracle/app/oracle/product
ALL EXCLUDE = TABLE:"IN ('EMP', 'CUST', 'SALES')"
Does anyone know of a way to find out what synonyms are messed up?
Thanks,
Howard
[oracle@oratest oracle]$ ./datapump.sh
Export: Release 10.2.0.2.0 - Production on Monday, 25 June, 2007 14:51:11
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Release 10.2.0.2.0 - Production
ORA-39001: invalid argument value
ORA-01775: looping chain of synonyms
[oracle@oratest oracle]$
--------------------------
This is my data pump script:
#!/bin/sh
/oracle/app/oracle/product
ALL EXCLUDE = TABLE:"IN ('EMP', 'CUST', 'SALES')"
Does anyone know of a way to find out what synonyms are messed up?
Thanks,
Howard
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
ASKER CERTIFIED SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
ORA-01775 looping chain of synonyms
Cause: Through a series of CREATE synonym statements, a synonym was defined that referred to itself. For example, the following definitions are circular:
CREATE SYNONYM s1 for s2
CREATE SYNONYM s2 for s3
CREATE SYNONYM s3 for s1
Action: Change one synonym definition so that it applies to a base table or view and retry the operation.
Cause: Through a series of CREATE synonym statements, a synonym was defined that referred to itself. For example, the following definitions are circular:
CREATE SYNONYM s1 for s2
CREATE SYNONYM s2 for s3
CREATE SYNONYM s3 for s1
Action: Change one synonym definition so that it applies to a base table or view and retry the operation.
ORA-39001: invalid argument value
Cause: The user specified API parameters were of the wrong type or value range. Subsequent messages supplied by DBMS_DATAPUMP.GET_STATUS will further describe the error.
Action: Correct the bad argument and retry the API.
Cause: The user specified API parameters were of the wrong type or value range. Subsequent messages supplied by DBMS_DATAPUMP.GET_STATUS will further describe the error.
Action: Correct the bad argument and retry the API.
/oracle/app/oracle/product
i have removed spaces after the exclude and before the TABLE word. I am not really sure whether the issue is because of this.
also changed DATA_EXPORT_LOG to DATA_EXPORT_DIR
Try this out.
i have removed spaces after the exclude and before the TABLE word. I am not really sure whether the issue is because of this.
also changed DATA_EXPORT_LOG to DATA_EXPORT_DIR
Try this out.
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
Oracle Database
--
Questions
--
Followers
Top Experts
Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.