My Oracle Support Banner

Many Interim Tables And Indexes Are Filling Up The GL And GL_NDX Tablespaces (Doc ID 287534.1)

Last updated on JUNE 24, 2024

Applies to:

Oracle General Ledger - Version 11.5.7 and later
Information in this document applies to any platform.

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

To view full details, 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 a vibrant support community of peers and Oracle experts.