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 -----------------------------------------------------------------