Hi all...
I've searched thru the archives, but didn't find what I was looking for. I have a database with a huge temporary tablespace. It's huge because the there is value for max_extent... now I can fix that, but my problem is that I can't seen to resize the tablespace:
> alter database datafile 'temporary.dbf' resize 500M;
alter database datafile 'temporary.dbf' resize 500M
*
ERROR at line 1:
ORA-03297: file contains used data beyond requested RESIZE value
But the tablespace is empty:
TABLESPACE Total Blocks Empty BLocks
------------------------------ ------------ ------------
TEMP 261632 260927
So what is preventing me from resizing it?
Thanks in advance
Cyril Jaouich (Conseiller Unix)
-------------------------------
Centre de support informatique CSI
----------------------------------
Tél 514-289-1122 x6237