Re: ORA-12838 please : Is possible to append two times to the same table before doing a commit
- From: "Juan Cachito Reyes Pacheco" <jreyes@xxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 1 Apr 2004 18:51:15 -0400
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@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.
--
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
-----------------------------------------------------------------
Other related posts:
