My Oracle Support Banner

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.