Rollback segments on the fly in 7.3.2

I'm working on a data loader that will load data into a temporary table in Oracle 7.3.2, and then run a PL/SQL procedure to update the current table from the temporary table. Unfortunately, I'm running out of rollback segment doing this because we have a large number of small rollback segments because the vast majority of the transactions are queries and not updates. Any updates not coming from the loader are usually limited to one record.

        What I'm wondering is if I can create a large (preferably unlimited) rollback segment and use it for my data loader, and then destroy it when I'm done. I know how to grab a rollback segment in my procedure, but in order to bring a rollback segment online, we need to take the database down.

        One thing is that we're running in 7.2.2 compatability mode. Will changing to 7.3.2 compatibility allow us to create a rollback segment on the fly?

Thanks for any input!
Mark Schaefer
(mschaefer_at_dsai.com) Received on Wed Jul 17 1996 - 00:00:00 CEST