Re: Parallel DML and parallel clause in 10g R2

priteshpjani_at_gmail.com wrote:
> Hi,
>
> We are getting very weird error and its being shown to Oracle ppl but
> no success so far. Can any one tell me how to get rid of such issue.
>
> We are doing bulk operation on table and for that using "alter session
> enable parallel DML" but after that if we are doing any bulk insert /
> update operation on table using aggregate functions its giving
> different value all the time.
>
> i.e.
>
> alter session enable parallel DML;
> insert /*+ append parallel */ into <<table>>
> select col1, sum(col2), sum(col3)
> from <<source table>>;
> commit;
>
> Has anyone encountered such issue?
>
> ~Pritesh

What issue? You didn't post any error messages and you didn't post any examples, and even your INSET statement is not your actual insert statement.

Please post a working demo that shows the problem see we can try it.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org