Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Temporary tablespace questions...

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US