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] 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 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