I want to drop and recreate a table with create table as select statement.
While I can extract constraint definitions as existing before dropping, I am not sure how Check contraint can be added to the table after recreating it since I see the check constraints names as existing now as
SYS_C0179 etc which indicate that the names are actually system generated.
While I can find out the check constraint definition from dba_constraints how do I add check constraint after recreating the table.