the high water mark of a datafile, meaning the highest data block ever
used you wont be able to shrink it down.
drop the temp tablespace and recreate it during a slow time.
joe
> [EMAIL PROTECTED] wrote:
>
> 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
--
Joe Testa
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joe Testa
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
