Hello all,
I have requirement to import constraints with VALIDATE post a 7 TB database import.. ( Import with the constraints is very slow.. as some of the tables have 19K partitions ) As it stands, it takes around 19 hours to enable it.. Can I parallelize it ? May be using PARALLEL DDL ?
Will this work ? Will it have any issues with dependencies or locking ? Has anyone tried this operation ?
Or may be have a script to enable all the dependent objects in a sequence ? Any help would be appreciated.
SQL> ALTER SESSION FORCE PARALLEL DDL PARALLEL 16;
Session altered.
Thanks in advance.