From oracle-l-bounce@freelists.org Thu Apr 1 15:29:54 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i31LTrF26922 for ; Thu, 1 Apr 2004 15:29:53 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i31LTro26917 for ; Thu, 1 Apr 2004 15:29:53 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 75A8B63441F; Thu, 1 Apr 2004 16:22:07 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 17249-86; Thu, 1 Apr 2004 16:22:07 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C84A8636997; Thu, 1 Apr 2004 16:21:06 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 01 Apr 2004 16:19:58 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8039663828A for ; Thu, 1 Apr 2004 16:18:42 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 15946-98 for ; Thu, 1 Apr 2004 16:18:42 -0500 (EST) Received: from mail.acelerate.com (mail.acelerate.com [200.105.128.132]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 22F12636FF0 for ; Thu, 1 Apr 2004 16:11:08 -0500 (EST) Received: (qmail 11795 invoked from network); 1 Apr 2004 21:06:49 -0000 Received: from dazasoftware.com (HELO org48l7d9ara8b) (200.105.151.94) by 0 with SMTP; 1 Apr 2004 21:06:49 -0000 Message-ID: <00a201c4182e$9ec2df30$2501a8c0@dazasoftware.com> From: "Juan Cachito Reyes Pacheco" To: Subject: ORA-12838 please : Is possible to append two times to the same table before doing a commit Date: Thu, 1 Apr 2004 17:16:29 -0400 MIME-Version: 1.0 Content-type: text/plain; charset=Windows-1252 Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 2329 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jreyes@dazasoftware.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 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 ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org 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 -----------------------------------------------------------------