RE: Who is using my datafile
- From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: <adar666@xxxxxxxxxxxx>, "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 8 Jul 2008 13:43:15 -0400
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
