Subpartition level parallel insert PL/SQL
@neeraj-iAaNcG
•
Oct 26, 2024
Oct 26, 2024
2.2K
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 #-Link-Snipped-#..
Can anybody help me with this?
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 #-Link-Snipped-#..
Can anybody help me with this?