Re: DBA Question!

hi

my favorite query is:

SELECT d.name, status, enabled, bytes, create_bytes, t.name FROM v$datafile d, v$tablespace t
 WHERE t.ts# = d.ts#
;

thomas

Nandakumar wrote:

> Hi
>
> could anyone give the name of the table that links TABLESPACE NAME with
> DATAFILEs?
>
> i want to know the available DATAFILES and the TABLESPACES on each of
> them.
>
> WOuld appreciate any help!
> Thanks
> --
> Nandakumar
> (N.Kumar_at_rocketmail.com)
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Sep 29 1999 - 03:46:46 CDT