| increasing RBS [message #54546] |
Thu, 21 November 2002 03:26  |
ssa
Messages: 8
Registered: November 2002
|
Junior Member |
|
|
|
may i know how to increase the Rollback Segment, i.e what is the command and syntax with example. please help me regarding this, by giving the answer or giving refernce of websites
|
|
|
|
|
|
| Re: increasing RBS [message #54570 is a reply to message #54546] |
Thu, 21 November 2002 21:16  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
You have to drop the rollback segment and re-create it with the desired storage parameters.
First check if someone is using this rollback segments, or this user will get its transaction terminated. You can use script like This one.
Then drop the rollback segment:
DROP ROLLBACK SEGMENT rbs_name;
And then create it back:
CREATE ROLLBACK SEGMENT rbs_name
TABLESPACE system
STORAGE
( INITIAL sizeK
NEXT sizeK
OPTIMAL sizeK
MAXEXTENTS UNLIMITED);
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
