1. Home >
  2. Apps >
  3. Groups >

Subpartition level parallel insert PL/SQL

Question asked by Neeraj Sharma in #Coffee Room on Dec 7, 2012
Neeraj Sharma
Neeraj Sharma · Dec 7, 2012
Rank B2 - LEADER
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? Posted in: #Coffee Room

You must log-in or sign-up to reply to this post.

Click to Log-In or Sign-Up