Re: DBA_DB_LINK entry

Do the following:
I am assuming you created a db_link accidently. What you need to do: 1: login as sys and check db_link view: select db_link, owner from dba_db-links;

2: if the db_link is owned by sys:
login as sya and drop the db_link ( drop database link <db_link_name> if owned by system, do the above as system if owned by another user, login as that user and do the above. else
you are good to go.

3: if the db_link is public, syntax is slightly different. drop public database link <db_link_name>

pl. email me if you have any further problems.

regards,

Ramanarao Chamarty
rchamart_at_temple.edu

Kenneth C Stahl (BluesSax_at_Unforgettable.com) wrote:
: Alan Saint wrote:
:
: > I fumble-fingered an entry that got entered into this VIEW.
: >
: > How do I properly delete any specific entry in DBA_DB_LINK?
: >
: > As best as I have been able to determine the DBA_DB_LINK is
: > a view on a couple of "dollar sign" tables. I've been told
: > that one should never directly manipulate data in such tables.
: > Why in the world does Oracle make it so easy to enter data into
: > this view without providing a similar easy why to delete or
: > correct wrong entries?
:
: Anything that you bring into existance with "create" your can get rid of
: with "drop".
:
Received on Mon Aug 02 1999 - 08:41:03 CDT