Problem with "INSERT" statement

From: Raj <rajeev_goel_at_infy.com>
Date: 12 Jul 2001 04:18:32 -0700
Message-ID: <bc311178.0107120318.36dcc0f6@posting.google.com>

Hi All,

we have a query like:

INSERT into T1 (

    Field1,
    Field2,
    Field3 )
SELECT

     Field1,
     Field2,
     Field3
FROM
     View1,
     Table2,
     Table3
WHERE
     Field1 between date1 and date2

The problem is that it takes hours to insert records into T1 table. But running the subquery (SELECT..... date2) displays the records in few seconds.

I have doublechecked, there is sufficient space in temporary, data & rollback segments.

Could any one throw light on this?? Is this an oracle bug??

Thanks & regards
-Rajeev Received on Thu Jul 12 2001 - 06:18:32 CDT