Thanks for the response of the last query that i have put in. This is a new one.
I have created a database. I have created a user in that particular database. I have also created a tablespace known as RBS. This is for the rollback segments. Now the question is How can i use the rbs tablespace for that particular user. Should i create a rollback segment and assign it to that particular user in that tablespace. I know that rollback segment is assigned to a aprticular transaction. I havent done that. But i read theoritically. Please help me in this practically.
The database is O8.1.6 and the OS is NT and i am running in a laptop. Kindly advice me on this.
Rollback segment is an object which every transactions can share access. So no users can be particularly pinned with a particular rollback segment. Simultaneous transaction can write into same rollback segment, even to same extent but not to same block. And transactions can't span accross rollback segments.
So you create one public rollback segment. And whenever a session is started, Issue the first command to set the transaction to a specific rollback segment.
And your's is i think an OLTP type of application, so create few rollback segments with lesser size.