Juan,
ORA-12838 is not a bug. It's well-known limitation of direct load.
-----Original Message-----
From: Juan Cachito Reyes Pacheco [mailto:jreyes@(protected)]
Sent: Thursday, April 01, 2004 5:51 PM
To: oracle-l@(protected)
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@(protected)>
To: <oracle-l@(protected)>
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@(protected)
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@(protected)
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@(protected)
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
-----------------------------------------------------------------
