Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
PL/SQL Release 12.1.0.2.0 - Production
CORE 12.1.0.2.0 Production
TNS for Linux: Version 12.1.0.2.0 - Production
NLSRTL Version 12.1.0.2.0 - Production
Hi,
I have a table of size 21M rows with average row length 117.
This table has 135 child tables with delete cascade and 8 parent tables. Also table has total 12 indexes defined out of that 1 is primary key index.
Requirement is to delete 9M records from this table based on a flag(delete_flag column value as Y).
Considering the volume of deletes and the number of child tables impacted, what is the best approach I can use to delete 9M records?
Note: If it can be done in couple of hours, we can request no other DB activity during that time.