Re: Where to find tablespace and datafile info

>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;
>

select * from dba_data_files;
select * from dba_tablespaces;

-- 
                     ------------------------------------
If you have a condom and sunscreen SPF 15 or greater, than it's safe to look at
                     http://www.panix.com/~gsa/index.html