Quote:
Originally posted by anujpathak
Bigest insert update delete on a table before commit won't be more then yr bigest table in the database if it is so u may keep bigest rollback segmenet equal to the bigest table size of yr database
make it online before yr process
use set transaction use rollbacksegment statment before process
make it ofline once u finished yr process
I do it this way it may help you too.
You have to do a commit before to use the set transaction use rollback segment rbs_big statement.