CODEWITHSUNDEEP
oracle-databaseplsqlparallel-processingpartitioning
Bhupesh Singal
Bhupesh Singal

Reputation: 31

PL-SQL Oracle dbms_parallel_execute for partitioned tables

We have update one of our table which has around 150 million rows for each partition and such 12 partition exists . We want to use dbms_parallel_execute functionality to achieve this but I am not able to figure out how to pass partition specification for creating the chunks.

Please let me know if you have some pointers.

Upvotes: 1

Views: 694

Answers (1)

jareeq
jareeq

Reputation: 451

Great idea of spiting data to equal size chunks. May be scary at first look but really works. You can adopt them to your update with dbms_parallel_execute.

https://stewashton.wordpress.com/2015/07/01/splitting-a-table-into-rowid-ranges-of-equal-size/

Upvotes: 1

Related Questions