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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: [Q] undo tablespace did not release space?? (less quoting)

Re: [Q] undo tablespace did not release space?? (less quoting)

From: Juan Cachito Reyes Pacheco <jreyes_at_dazasoftware.com>
Date: Fri, 26 Mar 2004 19:41:10 -0400
Message-ID: <000f01c4138b$d7ca5580$2501a8c0@dazasoftware.com>


The best we found to release space we use a script to recreate it, after a big import.
I didn't found a way to truncate it in the time I investigate it a way to reduce it.
Hope this script help you, to reduce your redo tablespace soon.

connect SYS/SYS_at_XXX as SYSDBA;
shutdown;
connect SYS/SYS_at_XXX as SYSDBA;
startup pfile=E:\oraXXX\init\initXXX.ora;

CREATE UNDO TABLESPACE TBL_UNDOS DATAFILE 'E:\oraXXX\datafiles\dfl_undoXXX' SIZE 50M
REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED; ALTER SYSTEM SET UNDO_TABLESPACE = TBL_UNDOS; ALTER TABLESPACE "TBL_UNDO" OFFLINE NORMAL; DROP TABLESPACE TBL_UNDO
INCLUDING CONTENTS AND DATAFILES; CREATE UNDO TABLESPACE TBL_UNDO DATAFILE 'E:\oraXXX\datafiles\dfl_undo_XXX' SIZE 50M
REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED; ALTER SYSTEM SET UNDO_TABLESPACE = TBL_UNDO; DROP TABLESPACE TBL_UNDOS
INCLUDING CONTENTS AND DATAFILES; ALTER DATABASE DATAFILE 'E:\ORAXXX\DATAFILES\DFL_UNDO_XXX' AUTOEXTEND ON MAXSIZE UNLIMITED; Juan Carlos Reyes Pacheco
OCP
Database 9.2 Standard Edition
----- Original Message -----

From: "Paul Drake" <discgolfdba_at_yahoo.com> To: <oracle-l_at_freelists.org>
Sent: Friday, March 26, 2004 7:38 PM
Subject: RE: [Q] undo tablespace did not release space?? (less quoting)



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Fri Mar 26 2004 - 17:41:10 CST

Original text of this message

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