I think that would circumvent the whole concept. As far as I know, you can't
turn it off for dml.

-----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
***********************************************************************
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender by replying to this message and then delete it from your system. Use, dissemination or copying of this message by unintended recipients is not authorized and may be unlawful. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Finally, the recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.
***********************************************************************

Oracle LazyDBA home page