set transaction use rollback segment SEGMENT_NAME;
>>the run your command


At 03:47 PM 1/31/03 -0500, Bernita Joseph wrote:
>HI all,
>
>One of the users want to delete about 500000 so records.
>How can I set the rollback segment exclusively to that user.
>
>Thanks
>
>--------
>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