Re: How to find which segment is in which a particular datafile?

From: Lionel Mandrake <nobody_at_nospam.nowhere.nohow>
Date: Fri, 16 Nov 2001 02:46:15 GMT
Message-ID: <X5%I7.148013$My2.87171540@news1.mntp1.il.home.com>

"Ed Wong" <ewong_at_mail.com> wrote in message news:a5ae1554.0111151836.410ddea3_at_posting.google.com...
> Hi,
>
> Is there any way(such as query system tables) to find out which
> segment is located in which particular datafile? The reason I asked
> is I have one datafile in index tablespace that need to do media
> recovery and I can only do it tomorrow. For today, I want to find out
> what indexes are in it so that I can tell what query kind of query
> will fail.
>
> Thanks,
> ewong

SQL> describe dba_extents
and
SQL> describe dba_data_files

should be enough to get you started...

HTH, -LM Received on Thu Nov 15 2001 - 20:46:15 CST