Database Administration (MOSC)

MOSC Banner

How to find what table is the view based on?

edited Dec 14, 2012 4:55PM in Database Administration (MOSC) 3 commentsAnswered
I want to find the base table of the view apps.ORG_ORGANIZATION_DEFINITIONS. But I am not sure which view will I be able to find that information?

I tried dba_views, but that doesn't have table_name column. I also tried dba_dependencies, it returns the following, but those are not what I was looking for. Please advise. Thank you very much.

SQL> select referenced_owner, referenced_name, referenced_type, referenced_link_name from dba_dependencies where owner='APPS' and name='ORG_ORGANIZATION_DEFINITIONS' and type='VIEW';

REFERENCED_OWNER
------------------------------
REFERENCED_NAME
----------------------------------------------------------------
REFERENCED_TYPE
------------------
REFERENCED_LINK_NAME

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