Re: ORA-01552

From: Reid Lai <reidlai_at_hk.super.net>
Date: Fri, 20 Nov 1998 22:53:54 +0800
Message-ID: <36558281.904C6DC1@hk.super.net>

Is there any small rollback segment online? If so, does SAP provide room for issuing SET TRANSACTION USE ROLLBACK SEGMENT your_large_rollback_segment?

Torsten Kleinblotekamp wrote:

> What happens if the rollback-segment is full or busy. Could this be the
> problem?
>
> Torsten Kleinblotekamp wrote:
>
> > We're using Oracle as database for SAP-R/3. During large updates we get
> > the Error 1552, but we had an public rollbacksegment (initial 10MB, next
> > 10MB, minextents 10, Maxextents 500MB). Why?

--
Best Regards,

Reid Lai <reidlai_at_hk.super.net>
Certified Oracle 7 DBA (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Fri Nov 20 1998 - 08:53:54 CST