|
-
Committing every 1000 or some arbitrary number of rows is easy with a simple pl/sql procedure, just delete in a loop, keep track, and after so many records commit.
If you can, take a cold backup before hand, and doing the deletes with a small pl/sql procedure is probably your easiest option. Otherwise you would have to do them all in one shot (or smaller shots if you did it yourself manually) and you would have to watch out for your RBS, and/or create a larger one to be used by the delete as was suggested.
I also didn't think nologging was an option but I was too lazy to check the docs this time :)
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
|