Re: [SPAM] - Parallel update on non-partitioned tables - allowed at 10/11g? - Email has different SMTP TO: and MIME TO: fields in the email addresses

On Mon, Nov 16, 2009 at 2:23 PM, Timur Akhmadeev
<Akhmadeev@xxxxxxxxxxxxxx> wrote:
>
> > So, it seems clear this is not allowed. Right?
> No. You are allowed to use PDML (with certain restrictions) on 
> non-partitioned tables for INSERT since 9iR1 and DELETE/UPDATE/MERGE since 
> 9iR2. Try to find a note called “Introduction to Parallel DML”

Thanks Timur - I guess you mean "Introduction to PDML" (Doc ID
201457.1). This seems to address the introduction of intra-partition
PDML (not quite the same as a non-partitioned table?) at 9i and
includes the following paragraph...

"How to enable Parallel DML?
... Also you will need to specify the parallel hint in the DML
statement or should have it defined during creation of the table. What
can happen is that the operation that read your data is parallelized.
Update and delete operations are not parallelized on nonpartitioned
tables."

And what are we to make of the paragraph from the 11g docs that I
originally quoted, specifically stating the very same - no PDML on
non-partitoned tables?

cam
--
http://www.freelists.org/webpage/oracle-l

Other related posts: