Re: ORA-12838 please : Is possible to append two times to thesame table before doing a commit

From: Tim Gorman <tim_at_sagelogix.com>
Date: Fri, 02 Apr 2004 12:00:49 -0700
Message-ID: <BC930671.129F4%tim@sagelogix.com>

Juan Carlos,
Please note that I did not suggest "joining" the two SELECT statements together into a single SELECT statement. What I suggested was running the two independent SQL statements UNION'd together. That is something different, as the UNION operator has no impact on the SELECT statements except an ORDER BY. And an ORDER BY clause should be pretty irrelevant for an INSERT operation...

I can't think of any reason why two separate INSERT ... SELECT operations cannot be merged into a single INSERT ... SELECT ... UNION ... SELECT operation?

Hope this helps...

-Tim

on 4/2/04 8:50 AM, Juan Cachito Reyes Pacheco at jreyes_at_dazasoftware.com wrote:

> Thanks Tim,
> that was only one example, to show the problem.
> the insert is of thousands of records, not only 5.
> The problems is that I can't do a join, because some circumstances can cause
> another insert.
> After the first insert data is changed and then is reinserted the second
> group. No way to use a join.
>
> As this is a hisctoric kind table, temporary tables are useless, there is no
> join.
>
> it seems this is a Oracle limitation, not other chance, when I asked I
> supposed there could be some workaround in Metalink or hidden hint not
> supported by oracle to allow it.

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_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
-----------------------------------------------------------------

Received on Fri Apr 02 2004 - 12:58:09 CST