ORA-01775: Cyclic string of synonyms

Asked Aug 07 '14 at 16:14

Active Aug 07 '14 at 16:20

Viewed 156 times

i have to import a table from an Oracle server to a MS SQL server. Therefor I have created a linked server (Linked_server_new) which is connected from the SQL server to the Oracle server trough a datasource (defined in a TNSNAMES.ora). The test of the connection was successfull.

my SQL statement:

SELECT * INTO SQL_table FROM OPENQUERY(Linked_server_new, 
'SELECT * FROM Oracle_table')

after this I've got following error message:

OLE DB provider "MSDAORA" for linked server "Linked_server_new" returned message "ORA-01775: Cyclic string of synonyms
".
Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing the query "SELECT * FROM Oracletabelle" for execution against OLE DB provider "MSDAORA" for linked server "APC_Verbindungsserver_neu".

I would be really happy if somebody has an idea.

edited Aug 07 '14 at 16:20

Dr.Avalanche

1,944
2
28
37

asked Aug 07 '14 at 16:14

Claudia Fechtner

You have a circular definition of synonyms somehow. See http://stackoverflow.com/questions/247090/how-to-debug-ora-01775-looping-chain-of-synonyms – OldProgrammer Aug 07 '14 at 16:25
This message pops up in some general cases when there is just something wrong with synonym, not necessarily a cycle. – kubanczyk Aug 08 '14 at 17:58
Hello, thanks for your support. The problem was that the tables wasn't in the database. – Claudia Fechtner Aug 13 '14 at 14:04

ORA-01775: Cyclic string of synonyms

0 Answers0