Conventional Parallel Inserts do Exist in Oracle 11
Posted
by jean-pierre.dijcks
on Oracle Blogs
See other posts from Oracle Blogs
or by jean-pierre.dijcks
Published on Mon, 28 Feb 2011 17:31:18 -0800
Indexed on
2011/03/01
7:29 UTC
Read the original article
Hit count: 328
Had an interesting chat with Greg about said topic and searching showed the following link to discuss this topic in some detail (no reason for me to repeat this).
insert /*+ noappend parallel(t1) */ into t1 select /*+ parallel(t2) */ * from t2 generates a load table conventional and does give you a parallel insert without doing a direct path insert.
As this is missing from the official documentation it is probably something few people actually know existed, so kudos to Randolf Geist.
© Oracle Blogs or respective owner