| rbs segments [message #58480] |
Sun, 31 August 2003 23:21  |
M. Khaled
Messages: 67
Registered: April 2002
|
Member |
|
|
what is the command to use a particular rollback segments.As far as I know this is like 'set transaction .........'What is the exack command?
when many transactons are done concurrently but failed to commit. what will be the remedy.Rollback segment need to be increased or anything else.
Why do we use temporary tablespace ? Is there any relation with rbs?
PLEASE ANSWER THE ABOVE............
|
|
|
|
| Re: rbs segments [message #58481 is a reply to message #58480] |
Mon, 01 September 2003 03:02  |
shesha
Messages: 24
Registered: August 2003
|
Junior Member |
|
|
1. The correct syntax is..
SET TRANSACTION USE ROLLBACK SEGMENT RBS1;
2. What is the error that you are getting?
3. Temporary tablespace are used for doing some temporary jobs like sorting this is nothing to do with RBS.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
