View Feed
group-icon
Coffee Room
Discuss anything here - everything that you wish to discuss with fellow engineers.
12940 Members
Join this group to post and comment.

Subpartition level parallel insert PL/SQL

Hello,

I was working on optimizing SQLs and tuning some long running queries and was stuck with this.

Is it possible to insert data from one table to another in parallel at sub partition level? By sub partition level I mean, If I have 16 sub partitions in my table, can I kick off parallel partition insert i.e. inserting rows from sub partition 1 to sub partition 1 and so on in parallel. Is it achievable using PL/SQL?

Tagging ianoop..

Can anybody help me with this?

Share this content on your social channels -