Would existing constraints and indexes applied to an old table, apply to a new table renamed like the old one after it's dropped?

Question

everything is in the question.

I have a table named tableA on which we have indexes and foreign keys and constraints.

I have to modify content in a column called column1. This being a production system, I want to

1) create a copy of tableA called tableA_temp
2) Perform the data change (some concatenation and regexp_replace)
3) Obtain validation that the change is correct
4) rename tableA to tableA_old
4) Rename tableA_temp to tableA.

Once renamed to tableA, would the constraints and indexes apply to the new tableA?

My guess is yes but I would need a little validation.

Answer 1

You can use the DBMS_REDEFINITION package to "re-organise" a table like this. It provides functionality for you to create a temporary table with modified contents of an existing table as you describe. It also allows you to copy over the grants, triggers, indexes etc to the new table, then switch the tables over so the temporary table becomes the live table.

See this article for a worked demo.

Answer 2

No.

Ok, it depends on if you create them on the copy.