My Oracle Support Banner

Troubleshooting TABLE_REORG Package issues - RDF Snapshot drop when process fails + TABLE_REORG Guide (Doc ID 1964291.1)

Last updated on JANUARY 25, 2024

Applies to:

Oracle Demantra Demand Management - Version and later
Information in this document applies to any platform.


Investigating TABLE_REORG Package issues.

Troubleshooting Steps

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
Troubleshooting Steps
 How to use it
 2. Check the table LOG_TABLE_REORG for recommendations.
 3. Run the recommendation from LOG_TABLE_REORG .
 NOT ENOUGH SPACE Tablespace TS_DP Has only 6079 MB free. Required: 4864
 No Sufficient privileges to run table_reorg.reorg
 ORA-14063: Unusable index exists on unique/primary constraint key
 PLS-00201: identifier 'VS_PROC' must be declared
 ORA-23539: table "DEMANTRA"."MDP_MATRIX" currently being redefined
 TABLE_REORG.REORG cannot run on table with no primary key
 ORA-32422: commit SCN-based materialized view log cannot be created on table
 ORA-42030: cannot online redefine table "DEMANTRA"."T_EP_CTO_DATA" with commit SCN-based MV log
 ORA-31600: invalid input value ORA$BASE for parameter VALUE in function SET_FILTER

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