Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-12839 on 9.2.0.4

Re: ORA-12839 on 9.2.0.4

From: Dusan Bolek <pagesflames_at_usa.net>
Date: 15 Jan 2004 02:02:20 -0800
Message-ID: <1e8276d6.0401150202.26bdce3a@posting.google.com>


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 Bolek
Received on Thu Jan 15 2004 - 04:02:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US