Re: DBA Question!

From: Jamie Schrumpf <hatterasNOSPAM_at_hotbot.com>
Date: 1 Oct 1999 03:44:12 GMT
Message-ID: <7t1amc$18g$1@ash.prod.itd.earthlink.net>

In article <wzII3.2251$S2.18185992_at_France.EU.net>, didier.lenquette_at_steria.fr says...
>
>check these tables and the dba_extents .
>A table can be on severals tablespaces !
>
>A+
>
>Nandakumar <N.Kumar_at_rocketmail.com> a écrit dans le 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.
>
>

Just did this today, let me see...

I think the v$datafile table has a column TS# which maps to the v$tablespace[s] table. Use a join to display both the tablespace name and the associated datafile. Not sure how this works with partitioned tablespaces.

HTH
--

---

Jamie Schrumpf Received on Thu Sep 30 1999 - 22:44:12 CDT