Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-12839 on 9.2.0.4
cerebruspipeline_at_yahoo.co.uk (c3r3bro) wrote in message news:<74f64a8f.0401141244.79205455_at_posting.google.com>...
> Definitely 9204, we upgraded after Oracle support pointed out the bug
> you mentioned. Didn't help though.
>
> Here's a simpler example:
>
> alter table emp parallel;
> alter table dept parallel;
> alter session enable parallel dml;
> delete emp;
> delete dept;
> ERROR at line 1:
> ORA-12839: cannot modify an object in parallel after modifying it
>
> You can see that dept has not been modified before the last statement,
> yet it still thinks it has. This is due to the constraint between the
> two tables.
That's even more strange. I can't reproduce this even on 9.2.0.1.
There must be some differences between your and my setup. Can you post
your parameters?
I do not think so this kind of behaviour could be platform specific,
so difference should be in some parameter.
P.S. All my 9is are fresh new installs, no migration involved.
-- Dusan BolekReceived on Thu Jan 15 2004 - 04:02:20 CST