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 MAY 07, 2019

Applies to:

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

Purpose

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
Purpose
Troubleshooting Steps
 Introduction
 Prerequisites
 Privileges
 Parameters
 How to use it
 1. Run TABLE_REORG.CHECK_REORG('T');
 2. Check the table LOG_TABLE_REORG for recommendations.
 3. Run the recommendation from LOG_TABLE_REORG .
 Errors
 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
 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
References

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