Views Based on which tables ?

[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