Re: How to determine DB_LINKS

Hi,

Usual way to see dependencies between objects is user_dependencies view. It seems that references on database links are not included in this view.

Try to select all sources from user_sources, user_triggers and user_views and find all occurences of @<database link name> using grep. It is not very elegant solution.

Andrew Protasov

> We are trying to document a database that has some database links in it.
> I'm familiar with the DBA_DB_LINKS view, but this doesn't provide enough
> information about the DML that makes up the link.
> Is there another view that gives the SQL statement that makes up the link?
>
> Thanks,
> Rob.
>
>
>
>
Received on Wed Dec 02 1998 - 14:44:26 CST