Re: ROLL BACKSSSS URGENT!!!!!!!!!!!

Rollback segments are common to all users. If you created all the rollback segments to be in tablespace RBS, that is what will be used.

If there are also any rollback segments in the USER_DATA tablespace, these are also common to all users.

If a transaction does not specify which rollback segment to use, Oracle assigns one in some internal fashion.

naveen_arora_at_my-dejanews.com wrote:

> hi,
>
> i have a small doubt..
> in a apllication , user is having default schema of USER_DATA.
> so the rollback segments the appication logged is as that user
> will be using the USER_DATA rollback segments or rollback segments
> on tablespace RBS ?
> thanks for any help
> naveen
>
> naveen_at_cdotd.ernet.in
> arora_n_at_hotmail.com
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Mar 02 1999 - 23:45:13 CST