Views Based on which tables ?

[Sonia]

HI,
Is there any way to find out on which
tables the views are built on.
Regards
sonia

[pnrdba]

Hi
If you have TOAD then extract the script of that view and you can find out from which tables it's built.

thanks

[shandj]

You can get the information of view from user_tab_columns table.

Retrieve Table_name, column_name from user_tab_columns for table_name like 'Viewname'

Thanks

[Sonia]

Hi,
I am working on unix machine and i don't
think TOAD is available on unix; is there
any other way ?
regards
sonia

[Sameer]

Originally posted by pnrdba
Hi
If you have TOAD then extract the script of that view and you can find out from which tables it's built.

thanks

Without TOAD its not possible

You can use TEXT column from any of these dba_views, user_views, all_views

TEXT column stores the defination of view

Sameer

[jovery]

If you don't have TOAD you can select the TEXT from the USE R_VIEWS view.

e.g.

SELECT text
FROM user_views
WHERE view_name = 'my_view';

Regards

[shandj]

select table_name, column_name from user_tab_columns where table_name like 'Viewname';

Thanks

[jmodic]

Originally posted by shandj
select table_name, column_name from user_tab_columns where table_name like 'Viewname';

This doesn't tell you anything about underlyning tables - the TABLE_NAME in the above query is in fact the name of the view 'Viewname'.

Maybe you could use any variant of the following:

SELECT referenced_name FROM DBA_DEPENDENCIES
WHERE owner='VIEW_OWNER'
AND name = 'MY_VIEW'
AND referenced_type = 'TABLE';

Although the query itself might be terribly slow and inefficient.

[badrinathn]

********************************************

Hi,
I am working on unix machine and i don't
think TOAD is available on unix; is there
any other way ?
regards
sonia
*********************************************


With TOAD, you can connect to any oracle DB that you will be able to access from local windows box. It's merely a front end tool...

There can't be Toad for WIN,T for U, T for Linux etc...

Badrinath

[Sonia]

Originally posted by badrinathn
********************************************

Hi,
I am working on unix machine and i don't
think TOAD is available on unix; is there
any other way ?
regards
sonia
*********************************************


With TOAD, you can connect to any oracle DB that you will be able to access from local windows box. It's merely a front end tool...

There can't be Toad for WIN,T for U, T for Linux etc...

Badrinath

Mr Badrinath,
i know that it is a tool,
and as far as my company is concerned, we dont have a single
machine running on windows.