Re: Where to find tablespace and datafile info
From: AMARENDRA B NETTEM <nettama_at_charlie.cns.iit.edu>
Date: 1997/07/24
Message-ID: <33D79789.31D2_at_charlie.cns.iit.edu>#1/1
Date: 1997/07/24
Message-ID: <33D79789.31D2_at_charlie.cns.iit.edu>#1/1
L. Tseng wrote:
>
> Hi,
>
> When create a tablespace/datafile, where is the size information
> stored in the system?
>
> For example:
>
> create tablespace test_data datafile 'test01.dat' size 10M reuse
> autoextend on next 5M maxsize 50M;
>
> Which table/view stored the maxsize info? Is FILEXT$ the only place
> or there is a view for it?
>
> Thanks for the help!
>
> Leslie
Hi Leslie,
check the data dictionary table DBA_DATA_FILES
-- AMARENDRA B NETTEM ( http://www.iit.edu/~nettama) Certified Oracle DBA WHITTMAN-HART Inc. CHICAGO.Received on Thu Jul 24 1997 - 00:00:00 CEST