Data Warehouse Summary Table Problem

I have a strange problem occuring with a data warehouse load. The platform is Oracle 7.3 on NT.

There is a piece of code that creates a summary table by selecting data from a view. Basically the code is as follows:

		Truncate table
                           insert into table 


                           (select field 1, field2... 

                             from view)

 The process hangs for hours when loading 1 table from a rather small view.

The strange thing about this situation is that the following code for the same table executes in about 30 seconds.

  		Drop table
                           Create table as


                           (select field 1, field2... 

                             from view)

Any ideas? Received on Sat May 10 1997 - 00:00:00 CDT