Who is using my datafile

From: Yechiel Adar <adar666_at_inter.net.il>
Date: Tue, 08 Jul 2008 20:09:25 +0300
Message-id: <48739F45.5050202@inter.net.il>

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.


Adar Yechiel
Rechovot, Israel


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

Original text of this message