How to Find The Base Table of Views

<<Back to DB Administration Main Page

Find Out The Base Table of a Views

You can find out the base table/tables of a view using query below

SQL> select referenced_owner, referenced_name, referenced_type
from dba_dependencies
where owner = 'SYS' and name = 'ALL_OBJECTS' and type = 'VIEW';