Re: views and synonyms
From: Svend Jensen <svend.jensen_at_it.dk>
Date: Tue, 11 Feb 2003 20:34:57 +0100
Message-ID: <3E495061.2040701_at_it.dk>
Date: Tue, 11 Feb 2003 20:34:57 +0100
Message-ID: <3E495061.2040701_at_it.dk>
V_$FILESTAT is a view on *fixed_table* V$FILESTAT, check the view v[_]$fixed_table.
Fixed tables can be removed by removing the database and instance(s).
regards
/Svend Jensen
T.S.Vivek wrote:
> 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:34:57 CET