DROP_TEMPS Drops Tmp_col_order4redef Temp Table Causing Next Run Of TABLE_REORG.REORG To Fail
(Doc ID 1608846.1)
Last updated on FEBRUARY 03, 2019
Oracle Demantra Demand Management - Version 220.127.116.11 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!