Re: views and synonyms

I hope you're not on a production database! It's very very dangerous to delete objects from Oracle's data dictionary, from what I heard. You could introduce some data integrity issues, and end up not able to start your database. And don't ask Oracle for help after you did such a thing. But if you want to go ahead anyway, this data dictionary view's definitions can be seen as user sys:

select text from dba_views where view_name = 'V_$FILESTAT';

Daniel

vivekhcu_at_yahoo.com (T.S.Vivek) wrote in message news:<35096384.0302110732.39f53647_at_posting.google.com>...
> how can i find the base table of a view or that of a synonym ?
> my purpose is to clear the entries in the v$filestat which is a
> synonym and can't be directly deleted.
Received on Tue Feb 11 2003 - 20:01:57 CET