Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Insert intotakes ages

Insert intotakes ages

From: valigula <valigula_at_gmail.com>
Date: Thu, 19 Jul 2007 04:19:25 -0700
Message-ID: <1184843965.170604.16200@k79g2000hse.googlegroups.com> 






Hi all.


Is it any reasonable reason why an "insert into select" stamment takes
ages to execute?


i mean when i execute only the select it takes about 30 sec, but if i
add the "insert into stamment" .. Yesterday I stopped the query after
3 hours and with no results.


 i could attach the code but it is a long query that cross several
tables.



has this append to anyone??



Thanks



A.
Received on Thu Jul 19 2007 - 06:19:25 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US