Re: Who is using my datafile
- From: "Andrew Kerber" <andrew.kerber@xxxxxxxxx>
- To: adar666@xxxxxxxxxxxx
- Date: Tue, 8 Jul 2008 12:47:54 -0500
Try select * from dba_segments where tablespace_name='whatever';
On Tue, Jul 8, 2008 at 12:09 PM, Yechiel Adar <adar666@xxxxxxxxxxxx> wrote:
> I have a RAC on windows.
> Oracle 9206.
> OCFS.
>
> I have five datafiles that have nothing in them.
> I mean that select * from sys.seg$ where file# between 6 and 11 return
> nothing.
>
> When I tried to decrease the size of the datafiles I got: the file contain
> data beyond the space I want to decrease to.
> I thought that maybe there are some temporary segments but all the users
> use temp as their temporary tablespace.
>
> TIA
>
> --
> Adar Yechiel
> Rechovot, Israel
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
Other related posts:
