Hi There,
I have a task of dropping partitions on a table in QA environment but maintain the data in it. So, I started with creating test tables based on the original tables.
So, when I have this test table, the partitions are gone. But the problem is constraints are also gone.
When I try to re create the constraints, I get the error that the constraint name already exists. (This is understandable).
So, when I try to drop constraints on the original table and recreate them on the test tables, there are multiple table's foreign keys being referenced.
Is there a way I can alter the constraints with any script rather than going through all the tables being referenced?
Any help in this regard is much appreciated!
Thanks in advance!