Rollback segment
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 ?
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.