Re: problem getting rid of an undo tablespace

From: Juan Cachito Reyes Pacheco <jreyes_at_dazasoftware.com>
Date: Tue, 16 Mar 2004 14:59:29 -0400
Message-ID: <002301c40b88$d28229a0$2501a8c0@dazasoftware.com>

Here is the process to recreate a too bin undo tablespace, it will help to delete the one you have.

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;

Original Message ----- From: "david wendelken" <davewendelken_at_earthlink.net> To: <oracle-l_at_freelists.org> Sent: Tuesday, March 16, 2004 2:30 PM Subject: Re: problem getting rid of an undo tablespace

>
> I have a problem with one of the files in my undo tablepace.
>
> Given that there are not any transactions to undo, it seemed simplest to
just drop the file.
> But I haven't been able to get the database to let me do that.
>
> So, I created a 2nd undo tablespace with the intention of taking the first
off line and then dropping it.
> But I haven't been able to get the database to let me take it off line.
>
> I found a parameter in my spfile called "undo_tablespace" which was set to
the old tablespace.
> I shut down the database, changed the entry to point to the new
tablespace, but the database would not open up.
>
> Any ideas on how to clear out the corrupted undo tablespace file?
>
> Thanks in advance!
>
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
>

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 Tue Mar 16 2004 - 12:59:03 CST