Help!

I was trying to run a script that updates several tables (w/ SQL Plus), after awhile i got a an error (from Command Prompt shell) - Unable to allocate log, archival required, Please acknowledge. I also got another error - unable to extent rollback segment (SQL Plus).

I created a much larger rollback segment for my transaction using SET TRANSACTION USE ROLLBACK SEGMENT x. however, I still get the same error.

Can anyone explain why I got an "- Unable to allocate log, archival required, Please acknowledge." error from what I am doing?

I please to create a bigger rbs to resolve the second error message. will this work? Another alternative is to breakdown my script into smaller ones and commit before running the next. Any suggestions?

BTW, Im running Oracle 8.1.6 on NT4 SP6a

Thanks, I hope to get a reply for you.

[Edited by D Maverick on 06-04-2002 at 02:27 AM]