Re: ORA-01552

From: <satar_at_my-dejanews.com>
Date: Fri, 06 Nov 1998 17:51:46 GMT
Message-ID: <71vcvi$dj0$1@nnrp1.dejanews.com>

Make sure you have PUBLIC rollback segments, and that the following parameter is in your init<sid>.ora file with the names of your Public Rollback segments:

rollback_segments = (r01,r02,r03,r04,r05)

Also, remember, whenever you change any setting in the init<sid>.ora, you must shut down the database and restart it. (kinda like NT...Unix Bigots Unite!)

Satar

In article <3642B321.3C6CB9F7_at_it-mannesmann.de>, Torsten Kleinblotekamp <torsten.kleinblotekamp_at_it-mannesmann.de> wrote:
> Yes 1552! I know the solution for 1555, but this 1552 I realy didn't
understand
> because:
> dba_rollback_segs shows we had an Rollbacksegment
>

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 Fri Nov 06 1998 - 11:51:46 CST