maybe,
insert /*+ append*/
???
"valigula" <valigula_at_gmail.com> wrote in message
news:1184846655.754365.92050_at_r34g2000hsd.googlegroups.com...
> Hi all
>
>
> oracle 9i
> When i execute a "insert into select" it takes ages. It took yesterday
> over 3 hours with no results, but when i execute just the select it
> takes 30 sec. has anyone has a similar problem.
>
> I did not post the query since cross several tables and use a few
> cases withing the select.
>
Received on Mon Jul 23 2007 - 06:45:12 CDT
