Re: ORA-12838 please : Is possible to append two times to the same table before doing a commit

From: Juan Cachito Reyes Pacheco <jreyes_at_dazasoftware.com>
Date: Thu, 1 Apr 2004 18:51:15 -0400
Message-ID: <011e01c4183b$d70b5e00$2501a8c0@dazasoftware.com>

Hi Mladlen the idea is this, maybe there is a hidden parameter, or some workaround to this.
I read in a previous post in this forum this seems to be a bug.

And I can't do a commit between them. >:)

SQL> CREATE TABLE TEST( A NUMBER ); Tabla creada.

SQL> INSERT /*+ APPEND */ INTO TEST SELECT ROWNUM FROM DBA_OBJECTS WHERE ROWNUM<
5;

4 filas creadas.

SQL> INSERT /*+ APPEND */ INTO TEST SELECT ROWNUM FROM DBA_OBJECTS WHERE ROWNUM<
5;
INSERT /*+ APPEND */ INTO TEST SELECT ROWNUM FROM DBA_OBJECTS WHERE ROWNUM<5

                          *

ERROR en lİnea 1:
ORA-12838: no se puede leer/modificar un objeto despuÚs de modificarlo en paralelo

Juan Carlos Reyes Pacheco
OCP
Database 9.2 Standard Edition
----- Original Message -----
From: "Mladen Gogala" <mgogala_at_adelphia.net> To: <oracle-l_at_freelists.org>
Sent: Thursday, April 01, 2004 5:49 PM
Subject: Re: ORA-12838 please : Is possible to append two times to the same table before doing a commit

On 04/01/2004 04:16:29 PM, Juan Pacheco wrote:
> Hi I have a serious problem

Try committing among the two. It will help.

-- 
Mladen Gogala
Oracle DBA
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Apr 01 2004 - 16:50:50 CST