Re: Data files in a tablespace.

From: Hans Forbrich <news.hans_at_telus.net>
Date: Fri, 01 Oct 2004 20:52:01 GMT
Message-ID: <Rrj7d.7360$223.7092@edtnps89>

Praveen wrote:

> Hi..All,
>
> I am using DBA studio to look at the oracle data dictionary . I
> connect as a normal user with out any DBA privileges & yet I am able to
> see the data file(s) associated to a particular table's tablespace. I
> thought the data files can only be viewed when you get connected as a DBA.
> So, from which table does the DBA Studio retrieve the data files list ?
>
> I am using Oracle 8i.
>
> TIA
>
>
> P

The user data dictionary & catalog are created using the SQL routines in $ORACLE_HOME/rdbms/admin. Look there for the actual tables (mainly created in SQL.BSQ) and the views.

G'luk
/Hans Received on Fri Oct 01 2004 - 15:52:01 CDT