don't have to restart. Create a bigger rollback and use this for your load.
You can drop this rollback afterwards or just put it offline.



At 04:17 PM 1/31/03 -0500, Bernita Joseph wrote:
>HI all,
>
>I have about 6 RBS. Each with the same size.
>Something like this:
>
>
>CREATE PUBLIC ROLLBACK SEGMENT RBS3
> TABLESPACE RBS
> STORAGE ( INITIAL 512K NEXT 512K OPTIMAL 32728K MINEXTENTS 8
> MAXEXTENTS 32728)
>
>Now will the RBS3 will be big enough to manage 500,000 records.
>If I change this RBS to unlimited will that help? Or do
>I need to create a new one. In that case don't hI have to restart the
>instance?
>
>Thanks!
>
>-----Original Message-----
>From: Jerome Roa [mailto:[Email Address Removed] Friday, January 31, 2003 3:52 PM
>To: LazyDBA.com Discussion
>Subject: Re: assign a rollback segment exclusively to a user,urgent
>
>
>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] >To subscribe: send a blank email to oracledba-[Email Address Removed] >Visit 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 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