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

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Thu, 1 Apr 2004 18:09:29 -0500
Message-ID: <4C9B6FDA0B06FE4DAF5918BBF0AD82CF03B45404@bosmail00.bos.il.pqe>

Juan,

ORA-12838 is not a bug. It's well-known limitation of direct load.

-----Original Message-----

From: Juan Cachito Reyes Pacheco [mailto:jreyes_at_dazasoftware.com] Sent: Thursday, April 01, 2004 5:51 PM
To: oracle-l_at_freelists.org
Subject: Re: ORA-12838 please : Is possible to append two times to the same table before doing a commit

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=DDnea 1:
ORA-12838: no se puede leer/modificar un objeto despu=DAs de modificarlo = en
paralelo

Juan Carlos Reyes Pacheco
OCP
Database 9.2 Standard Edition
----- Original Message -----=20

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.

--=20

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


-----------------------------------------------------------------

----------------------------------------------------------------

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 - 17:06:05 CST