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