Re: Temporary tablespace questions...

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
> Jaouich.Cyril_at_hydro.qc.ca 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: teci_at_the-testas.net

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: ListGuru_at_fatcity.com (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).