Database Administration (MOSC)

MOSC Banner

Problem in dropping a DBLink

edited Nov 30, 2009 2:28AM in Database Administration (MOSC) 7 commentsAnswered
Hi!

I have a problem dropping a Database Link. When I drop it and later do a select "Select * from dba_db_links where DB_LINK='Name of the Db_Link'" it gets a row with the DbLink information, but when I try to reuse it (even after creating it agian), it shows the ORA-00600 error.

I have tried to recreate the DBLink, but the information obtained with "Select * from dba_db_links where DB_LINK='Name of the Db_Link'"  shows the information as if the DBLink was created the first time (I mean the first time it was created the 20 November, so It shows this date even if I create it today).

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center