|
-
Hi
Create a huge table space, create a rollback segment with initian and next say 500M min extents 5 make the optimal as 2 GB.
and before the update give the command
set transaction rollback segment segment_name;
this will make sure that you use only this rollback segment that you have just created.
Regards
Amar
Amar
"There is a difference between knowing the path and walking the path."

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
|