DROP_TEMPS Drops Tmp_col_order4redef Temp Table Causing Next Run Of TABLE_REORG.REORG To Fail

(Doc ID 1608846.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

Customer mentions that they found that standard program DROP_TEMPS is actually dropping standard temp table tmp_col_order4redef. This error cause the function redef$_col_order becomes invalid.
Moreover because of this, the next run of TABLE_REORG fails with the following error:

BEGIN table_reorg.reorg(user,'MDP_MATRIX','R'); END;
*
ERROR at line 1:
ORA-00900: invalid SQL statement
ORA-06512: at "DEMANTRA_UF.TABLE_REORG", line 793
ORA-00955: name is already used by an existing object
ORA-06512: at line 1



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