Database Administration (MOSC)

MOSC Banner

How to identify the Column Dependency objects from data dictionaries/ Queries

edited Jun 6, 2013 8:40AM in Database Administration (MOSC) 7 commentsAnswered
 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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center