-
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]
The Maverick
Oracle Certified DBA - 8i
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|