Hi Guys,

I have confusion about whether INSERT..SELECT can be run as parallel DML against 8.0.5.

I have read somewhere that Oracle doesnot run INSERT..SELECT in Parallel unless run as Direct Load with APPEND hint.

NOTE: Following exists before executing INSERT..SELECT
* Parallel DML is enabled.
* The table being inserted has Parallel degree pre-defined and/or the SELECT SQL has suppied with PARALLEL hints and/or the table being queried has Parallel degree pre-defined.
* Enough PQ Servers are available/running.
* Hardware supports Parallel DML.
* Instance has been started with enough various memory pockets.

Your feedback is greatly appreciated.