Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: DBA_DB_LINK entry
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
![]() |
![]() |