My Oracle Support Banner

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 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

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