Data load/unload

Hello all, I am trying to create a datawarehouse ( 15 GB in size) by exporting data out of our production database (60 GB in size). One of the tables has about 15 million rows and when I try to load into the warehouse using 'insert into DW_TAB1 SELECT * from PROD_TAB2;' the transaction is aborted. I cannot do a partitioned select statement to reduce the the result set. Also, I tried to unload the data from the tables into a ascii file and load it into the datawarehouse. But, this process is excruciatingly slow. I need to load the data everyday. After the first full import is completed, is there any way to do a incremental unload from the production database and an incremental import into the datawarehouse??? TIA Nadella -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own