Hi,
I have used the dbms_parallel_execute utility to split a large DML into smaller transactions.
I usually do something like this.
BEGIN
dbms_parallel_execute.create_chunks_by_rowid
(task_name => <task name>,
table_owner => <owner>,
table_name => <table>,
by_row => false,
chunk_size => 10000);
END;
/
I now have to do a large delete (~94 million rows) on a single partition. I can't truncate the partition since there are other rows (~300 million) that still have to be retained.
Is there a way I can split a single partition (instead of the whole table) into chunks?
I can create a temp table with the rows I want to keep and then swap partitions. But I wanted to see if dbms_parallel_execute has an option to achieve this.
Thanks!