Hi All,
Good Morning !!
I have a requirement where I need to find out the DB Objects which are using certain Remote Database Links.
I know could do that by using the below query :
select * from dba_dependency where referenced_link_name = 'sample_dblink';
But the above sql is not giving the results for any Oracle Views which is using remote db links.
It is giving the results for procedures and packages using database links within them.
For Example,
Say I have created a view :
CREATE OR REPLACE VIEW V_SAMPLE1 AS
SELECT * FROM T_TABLE@DB_LINK2;
Where the view V_SAMPLE1 is created in DATABASE1 which is pointing to a table T_TABLE in DATABASE2 via remote database link DB_LINK2
Now,
When I try to select this from DBA Dependency :
select * from dba_dependency where name = 'V_SAMPLE1';
I am not getting any rows.
OR
If I try with select * from dba_dependency where referenced_link_name = 'DB_LINK2';
I am not getting the view V_SAMPLE1 in the results.
What I need to know is , where does Oracle store the dependency information of the Views which are using Remote Database Links (if its not in dba_dependency).
I am using Oracle 10g.
Many thanks in advance for your time.
Regards,
IM.