Large Roll Back Segment

[naushi]

I run a script that refreshes a materialized view. I force the script to use a specific RBS
say 'VLRB1' for the large size it needs. Is it possible to dynamically turn the RBS online when I start the script and turn it off-line after the script is done. I want to do this to make sure that the RBS is available when I start the script and no other job can use it.

If there is another way to ensure the availability of the RBS please advise. Regards,
Naushi Hussain
Naushi.hussain@honeywell.com

 

[JJSmith]

alter rollback segment VLRB1 online;

run script .....

alter rollback segment VLRB1 offline;

 

[naushi]

thanks for your reply. one more question. What permission does this user need to be able to turn the RBS online and offline. I would not like to give DBA privs to this user. Regards,
Naushi Hussain
Naushi.hussain@honeywell.com

 

[mgavidia]

Need to grant Alter rollback segment priv.
Example: GRANT ALTER ROLLBACK SEGMENT TO SCOTT;