Re: rollback space

From: <manish.nevrekar_at_gmail.com>
Date: 3 Feb 2005 07:38:31 -0800
Message-ID: <1107445111.105482.184560@g14g2000cwa.googlegroups.com>

The records are inserted using a PL/SQL procedure, using "BULK COLLECT". I also tried setting the indexes unusable and then rebuilding them after the load, this process actually takes more time because we are loading about 150k rows in a 50 million row table. The other thing i tried was to use partition exchange, but the problem is that the data in the original partition (one that is a part of the table) is lost.
Append is not very helpful in this case because as i have mentioned before the table has 2 large indexes. The redo/ rollback will always be written for them.

I appreciate all you comments. Welcome any more comments.

Manish Received on Thu Feb 03 2005 - 09:38:31 CST