How to identify the Column Dependency objects from data dictionaries/ Queries
We use DBA_DEPENDENCIES to identify the dependent object for the particular object.
Eg For a view we can identify the dependent object /table using dba_dependencies, can we identify the dependent columns?
create view test_view as select empno,ename from scott.emp;
select OWNER,NAME,REFERENCED_OWNER,REFERENCED_NAME,REFERENCED_TYPE from dba_dependencies where NAME='TEST_VIEW';
OWNER NAME REFERENCED_OWNER REFERENCED REFERENCED_TYPE
-------------------- ------------------------------ ------------------------------ ---------- ------------------
SYS TEST_VIEW SCOTT EMP TABLE
I am looking for ways without having to review the views DDL. In Prod system,there would be lot of complex views involving several tables.
0