Re: Dropping rollback segment

From: <satar_at_my-dejanews.com>
Date: Wed, 04 Nov 1998 22:04:45 GMT
Message-ID: <71qj1t$1gi$1@nnrp1.dejanews.com>

When you do a shutdown immediate, it will rollback any uncomited transactions. Also, if you have usernames that no one uses, then as SYSTEM or SYS, login into the database and change thier passwords or you can drop them if you like.

Satar

In article <71pt8q$t4q1_at_tmpsp002.tmpprv.allied.com>, "Zachary Agatstein" <Zachary.Agatstein_at_atsc.allied.com> wrote:
> I needed to increase the size of my rollback segments, so I created new,
> larger ones, and then took offline the old ones, so I could drop them. One
> rollback segment remains "PENDING OFFLINE", caused probably by a user who
> did not complete his or her transaction.
>
> Is there a way to force this transaction completed? There are a couple of
> usernames that nobody uses anymore, and the passwords are forgotten...
>
> What happens to a pending transaction when the database instance is shut
> down? Will this action result in completion of all pending transactions?
>
> Thanks
>
> Zach Agatstein
>
>

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Nov 04 1998 - 16:04:45 CST