Re: ORA-12838 please : Is possible to append two times to thesametable before doing a commit
- From: "Juan Cachito Reyes Pacheco" <jreyes@xxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 2 Apr 2004 15:10:14 -0400
Thanks
Juan Carlos Reyes Pacheco
OCP
Database 9.2 Standard Edition
----- Original Message -----
From: "Tim Gorman" <tim@xxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Friday, April 02, 2004 3:00 PM
Subject: Re: ORA-12838 please : Is possible to append two times to
thesametable before doing a commit
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@xxxxxxxxxxxxxxxx
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@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:
