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 7.3.1.4 and laterInformation 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 |
| 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 |
| References |