Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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.