| question about rollback segments [message #57606] |
Wed, 25 June 2003 09:46  |
fengq
Messages: 38
Registered: October 2002
|
Member |
|
|
Hi, why everytime I restart the database, all my rollback segments becomes offline??? I am able to place them online. my version is 8.1.7
thanks so much for helping
|
|
|
|
| Re: question about rollback segments [message #57608 is a reply to message #57606] |
Wed, 25 June 2003 10:27  |
ctg
Messages: 146
Registered: July 2002
|
Senior Member |
|
|
SELECT owner, segment_name FROM DBA_ROLLBACK_SEGS;
If the owner is SYS (meaning they are private), then simply put them in your init.ora file
ROLLBACK_SEGMENTS = (rbs1, rbs2,..,rbsn) -- this parameter brings these PRIVATE rollback segments online when the db opens.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
