Re: No Rollback Segments in Database

From: Thorsten M. Wahl <twahl3_at_compuserve.de>
Date: Thu, 10 Oct 2002 11:41:10 +0200
Message-ID: <ao3hqg$74q$1@nntp-m01.news.aol.com>

Hello.

Check as "System": select * from dba_rollback_segs; Are all RBs online?

If not, set: rollback_segments = (RB0, RB1) in initorc1.ora

Worked for me in 8.0.3 using NT.

Thorsten

"Randy Harris" <randy.harris_at_nospam.net> schrieb im Newsbeitrag news:262p9.3026$F53.2842529_at_newssvr28.news.prodigy.com...
> I installed 8.1.7 on Windows 2000. I used the Configuration Assistant to
> create a new database, I selected Custom and set the sizes for the
> tablespaces. I had problems using the database and tracked it down to
lack
> of any public rollback segments, only one for System. There was an RBS
> tablespace, but no rollback segments within it.
Received on Thu Oct 10 2002 - 04:41:10 CDT