Re: OT My weekly tip: how to execute several appends without commit
- From: "Juan Cachito Reyes Pacheco" <jreyes@xxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 12 Apr 2004 14:55:28 -0400
Hi Jared, in a previous post I talk about,
the problem was you can't do two consecutive appends before a commit.
This is a bug or limitation in the append process.
The name of the post, in this list, was
"ORA-12838 please : Is possible to append two times to the same table before
doing a commit"
And this was the question:
Hi I have a serious problem
I can't do two append insret to a table in a same transaction, and I can
join in only one.
because some times the same process( a function) must be runs more than once
and can't be a commit between them, all is only one transaction.
I ask you if you please know about a trick to bypass this.
SQL> INSERT /*+ append */ into ctb.xxdeftra select * from ctb.deftransace_me
whe
re rownum <5;
4 filas creadas.
SQL> INSERT /*+ append */ into ctb.xxdeftra select * from ctb.deftransace_me
whe
re rownum <5;
INSERT /*+ append */ into ctb.xxdeftra select * from ctb.deftransace_me
where ro
wnum <5
*
ERROR en lÝnea 1:
ORA-12838: no se puede leer/modificar un objeto despuÚs de modificarlo en
paralelo
before doing a commit
Thanks :)
Juan Carlos Reyes Pacheco
OCP
Database 9.2 Standard Edition
----- Original Message -----
From: <Jared.Still@xxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Monday, April 12, 2004 2:39 PM
Subject: Re: OT My weekly tip: how to execute several appends without commit
Tom Kyte gave a good idea to do several inserts in a table, based on
distinct state in tables
without doing a commit.
For example
/*+append */ insert into a select * from b
(several process modify b) then
/*+append */ insert into a select * from b
----------------------------------------------------------------
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:
