Re: DBA Question!

Join (see desc's below)
sys.ts$.ts# = sys.file$.ts#
sys.file$.file# = v$datafile.file#

or just query dba_data_files
SQL> desc dba_data_files

 Name                            Null?    Type
 ------------------------------- -------- ----
 FILE_NAME                                VARCHAR2(257)
 FILE_ID                                  NUMBER
 TABLESPACE_NAME                          VARCHAR2(30)
 BYTES                                    NUMBER
 BLOCKS                                   NUMBER
 STATUS                                   VARCHAR2(9)



SQL> desc sys.ts$
 Name                            Null?    Type
 ------------------------------- -------- ----
 TS#                             NOT NULL NUMBER
 NAME                            NOT NULL VARCHAR2(30)
 OWNER#                          NOT NULL NUMBER
 ONLINE$                         NOT NULL NUMBER
 UNDOFILE#                                NUMBER
 UNDOBLOCK#                               NUMBER
 BLOCKSIZE                       NOT NULL NUMBER
 INC#                            NOT NULL NUMBER
 SCNWRP                                   NUMBER
 SCNBAS                                   NUMBER
 DFLMINEXT                       NOT NULL NUMBER
 DFLMAXEXT                       NOT NULL NUMBER
 DFLINIT                         NOT NULL NUMBER
 DFLINCR                         NOT NULL NUMBER
 DFLEXTPCT                       NOT NULL NUMBER

SQL> desc sys.file$
 Name                            Null?    Type
 ------------------------------- -------- ----
 FILE#                           NOT NULL NUMBER
 STATUS$                         NOT NULL NUMBER
 BLOCKS                          NOT NULL NUMBER
 TS#                             NOT NULL NUMBER

SQL> desc v$datafile
 Name                            Null?    Type
 ------------------------------- -------- ----
 FILE#                                    NUMBER
 STATUS                                   VARCHAR2(7)
 ENABLED                                  VARCHAR2(10)
 CHECKPOINT_CHANGE#                       NUMBER
 BYTES                                    NUMBER
 CREATE_BYTES                             NUMBER
 NAME                                     VARCHAR2(257)

Nandakumar wrote in message <7sr6j4$ms5$1_at_nnrp1.deja.com>...
>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 Tue Sep 28 1999 - 15:59:33 CDT