Re: Where to find tablespace and datafile info

Gary Assa wrote:
>
> >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

Come on, Gary, don't torture him...

select * from sys.dba_tablespaces where tablespace_name = 'TEST_DATA'; select * from sys.dba_data_files where tablespace_name = 'TEST_DATA';

I doubt he wants to see 50 screens-worth of output to find the info for his one tablespace.

• TRW -- ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| | Tim Witort || He is not silent. He is not | | trwATmedicalertDOTorg || whispering. We are not quiet | | || we are not listening. | | Pin: TZ, only one :^( || - Out of the Grey | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||