Are the indexes and constraint valid?
Hi! We have an Oracle DB 12c (12.2).
There are two tables (TBL and TBL_HIST) which have exactly the same table structure, indexes and constraint, of cause the names are different. Both have existing data but not the same. We have to do below things to them...
1. Rename TBL to TBL_TEMP, rename its indexes to another name (e.g. TBL_0 to TBL_TEMP_0, TBL_1 to TBL_TEMP_1, etc) and rename constraint on this table to another name (e.g. TBL_PK to TBL_TEMP_PK).
2. Rename table TBL_HIST, its indexes and constraint to the same as TBL previously was (yes, the same name of another table. e.g. table TBL_HIST to TBL, indexes TBL_HIST_0).