Who is using my datafile
- From: Yechiel Adar <adar666@xxxxxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 08 Jul 2008 20:09:25 +0300
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