RE: Who is using my datafile

From: Mercadante, Thomas F (LABOR) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Tue, 8 Jul 2008 13:43:15 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FFE090A2@EXCNYSM0A1AJ.nysemail.nyenet>


Yechiel,

You have a database objects in those datafiles/tablespaces. Look in DBA_TABLES or DBA_INDEXES to see what is being stored there. You can then look in DBA_EXTENTS to see what object is using the high-disk locations. You can then move these objects to another tablespace (or even the same one) to clear the space to allow you to shrink the file.

Hope this helps.

Tom

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Yechiel Adar Sent: Tuesday, July 08, 2008 1:09 PM
To: ORACLE-L
Subject: Who is using my datafile

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

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Tue Jul 08 2008 - 12:43:15 CDT

Original text of this message