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

  • From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 1 Apr 2004 18:09:29 -0500

Juan,

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

-----Original Message-----
From: Juan Cachito Reyes Pacheco [mailto:jreyes@xxxxxxxxxxxxxxxx]
Sent: Thursday, April 01, 2004 5:51 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: