Large Amount Of Archive Log Files Are Generated During Mgp Process And Compose/Apply Cycle Error

(Doc ID 1199103.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Lite - Version and later
Information in this document applies to any platform.
***Checked for relevance on 07-Aug-2013***


On : version, Mobile Server

When attempting to Compose/apply the data the MGP fails with the error Ora-00942 and it does not truncate the CLG$tables which increase the Amount of Archives.


The issue can be reproduced at will with the following steps:
1. start MGP
2. All the MGP Cycle fails with the Error Ora-00842
3. the MGP does not truncate the clg$tables and keep all their records which are composing again and increase the Amount of Archives.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms