Such error occurs when there is
a db link which is a loop back database link i.e. points to
itself
-- So to fix the issue rename the global_name to something else SQL > Alter database rename global_name to TEMP.XXXX; Database altered. -- After changing global name one is able to drop the database link and after dropping the database link you can rename the global names SQL> DROP DATABASE LINK TESTDB.WORLD; Database link dropped. SQL> Alter database rename global_name to TESTDB.WORLD; Database altered. |