Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DBA_DB_LINK entry

Re: DBA_DB_LINK entry

From: Hans-Friedrich Pfeiffer <Pfeiffer.Hans-Friedrich_at_t-online.de>
Date: Sat, 07 Aug 1999 00:39:09 +0200
Message-ID: <37AB640D.6C68618D@t-online.de>


Hi Alan,

you like adventures ? Never, NEVER issue a ´insert´ or ´update´ o= r
´delete´ directly
to system tables. You created a database link ? Did you a ´insert into ...´ ????
In this case, please read the manuals or ask someone how knows better. In the other case : drop [ public ] database link ... will work !

Greetings Hans

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?
Received on Fri Aug 06 1999 - 17:39:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US