DROP_TEMPS Drops Tmp_col_order4redef Temp Table Causing Next Run Of TABLE_REORG.REORG To Fail
Last updated on MARCH 08, 2017
Applies to:Oracle Demantra Demand Management - Version 126.96.36.199 and later
Information in this document applies to any platform.
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms