 | | | ORA-12838 please : Is possible to append two times to thesametable before do | ORA-12838 please : Is possible to append two times to thesametable before do 2004-04-02 - By Juan Cachito Reyes Pacheco
Back
Thanks
Juan Carlos Reyes Pacheco
OCP
Database 9.2 Standard Edition
-- -- Original Message -- --
From: "Tim Gorman" <tim@(protected)>
To: <oracle-l@(protected)>
Sent: Friday, April 02, 2004 3:00 PM
Subject: Re: ORA-12838 (See http://ORA-12838.ora-code.com) 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@(protected)
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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
|