Temporary tablespace questions...

From: <Jaouich.Cyril_at_hydro.qc.ca>
Date: Thu, 09 Aug 2001 17:20:21 -0700
Message-ID: <F001.003661B0.20010809123118@fatcity.com>

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 Received on Thu Aug 09 2001 - 19:20:21 CDT