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: 295

Filed under:

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