Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01552
dba_rollback_segs shows the rollback-segment ist online! We insert al lot of rows
in many other tables and had no problem. this problem occures only for a few
tables.
In details: We make a client copy in SAP R/3, than means we copy about dublicate
the rows of about 8000 tables (changing the client column). But as I told we had
this Problem only for a few tables (after we copy 3000 tables)
satar_at_my-dejanews.com wrote:
> 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 Mon Nov 09 1998 - 01:08:41 CST