Problem Inserting Millions of records into a table from another table.

Hello Experts,

The client provides 1 Million of data(records/rows) each day, and using DB Link we retrieve the data and store in custom table say XX_TRANSACTIONS.From XX_TRANSACTIONS the data is populated to three different tables say XX_DAILY, XX_PTD, XX_YTD for reporting purpose, grouped by branch, GL, currency using three different custom procedures respectively.

I have a problem inserting Millions of these data into the XX_DAILY, XX_PTD, XX_YTD tables from XX_TRANSACTIONS table.Whenever i run these procedures most of the time it completes with error because of the Temp Space.And mostly it consumes much time to insert data.I use the normal insert statement in the procedure.