Re: Deleting a rollback segment

From: Jim Gregory <Jim.Gregory_at_ncr.com>
Date: Wed, 25 Apr 2001 13:13:58 -0400
Message-ID: <3ae70603$1@rpc1284.daytonoh.ncr.com>

alter rollback segment <name> offline;
drop rollback segement <name>;

then rerun your script. My guess is that you may run into more of this or similar problems. It might be best to blow away everything and restart the create database stuff again. Read through your 3rd party's scripts to see exactly what and how they're doing things.

--
Jim Gregory
Principal Consultant for Keane, Inc.
Currently assigned to NCR, Dayton, OH

Opinions are my own and do not reflect those
of my employer or clients
"Ernesto" <ernesto.moreno_at_POR_FAVOR_NO_SPAM_katamail.com> wrote in message
news:3ae68b83.697148556_at_news.sarenet.es...


> Hi!

>

> I've installed an Oracle instance, but a 3rd party

> software manages it, and creates a DataBase.

>

> When installing the DataBase, an O/S error happened,

> and when re-starting again, I get this message:

> "ORA-01535: rollback segment XXX already exists."

>

> I suppose that this 3rd party software has created the

> rollback segment before O/S crashed.

>

> Anybody knows how to solve this?

>

> Thankx.

> ==========

> MIRELLO

Received on Wed Apr 25 2001 - 12:13:58 CDT