CTO Load Procedure Fails Intermittently
(Doc ID 1136705.1)
Last updated on MAY 23, 2019
Applies to:Oracle Demantra Demand Management - Version 7.3.0 to 7.3.0 [Release 7.3.0]
Information in this document applies to any platform.
Run the workflow IMPORT CTO_LEVEL.
The error seen in the collaborator logs is as follows:
2010-02-12 15:26:02,168 EST [WFProcess_11] FATAL workflow.general: java.sql.SQLException: ORA-01555: snapshot too old: rollback segment number 17 with name "_SYSSMU17_1257869570$" too small
The undo tablespace is defined as 65Gigs. The client also has EBS Suite and the rollback segment is defined as 19 Gigs.
Why does this process need in excess of 65 Gigs as rollback segment?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document