Many Interim Tables and Indexes are filling up the GL and GL_NDX tablespaces (Doc ID 287534.1)

Last updated on OCTOBER 01, 2016

Applies to:

Oracle General Ledger - Version 11.5.7 to 11.5.10.2 [Release 11.5.7 to 11.5.10]
Information in this document applies to any platform.
***Checked for relevance on 29-12-2011***


Symptoms

Many automatically generated tables/indexes. causing a number of segments created in tablespace GL and GL_NDX.

Examples of tables in tablespace GL:
GL_CONS_INTERFACE_%;
GL_CONS_INTERIM0_%;
GL_INTERCO_BSV_INT_%;
GL_INTERCO_LINES_INT_%;
GL_SEGVAL_INHERIT_INT_%;
...
Examples of indexes in tablespace GL_NDX
GL_CONS_INTERFACE_%_N2
GL_CONS_INTERIM0_%_U1
GL_IC_BSV_INT_%_U1
GL_IC_LINES_INT_%_N1
GL_INTERCO_BSV_INT_%_U1
GL_INTERCO_LINES_INT_%_N1
GL_SEGVAL_INHERIT_INT_%_U1
...

This is filling up the tablespace.

Cause

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