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 26, 2019
Applies to:Oracle Demantra Demand Management - Version 18.104.22.168 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
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