Re: Where to find tablespace and datafile info

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.