Try
set transaction use rollback segment <RBS name> to set a RBS for a
transaction.

and
ALTER ROLLBACK SEGMENT <RBS name> OFFLINE;
to take them offline.

Shashi
-----Original Message-----
From: Ryan, Dan [mailto:[Email Address Removed] Friday, June 28, 2002 1:01 PM
To: LazyDBA.com Discussion
Subject: Not using Rollback segments in SQL


Guru's,

Is there a command line parameter in SQL to turn off the use of rollback
segments for a large, one time, update and set command?




--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page