| Rollback segment [message #50542] |
Wed, 20 March 2002 20:16  |
Ravi
Messages: 251
Registered: June 1998
|
Senior Member |
|
|
While creating the database using a script I have created the rollback segment as below and made it online.
CREATE ROLLBACK SEGMENT ids_roll_priv1
TABLESPACE ids_rollback_data
STORAGE (initial 50K next 50K);
ALTER ROLLBACK SEGMENT ids_roll_priv1 ONLINE;
But every time the Oracle service is stoped the rollback segment is offline and my inserts will fail and I have to make the segment online everytime I start my Oracle service.
Please provide me the solution.
Thanks,
Ravi
|
|
|
|
| Re: Rollback segment [message #50544 is a reply to message #50542] |
Wed, 20 March 2002 23:29  |
seng
Messages: 191
Registered: February 2002
|
Senior Member |
|
|
To set rollback segment online when each time restarting database with specify in parameter file (initSID.ora) in ROLLBACK_SEGMENTS with your rollback segment name.
Hope this is helping
|
|
|
|
| Re: Rollback segment [message #50558 is a reply to message #50542] |
Thu, 21 March 2002 04:31 |
tommy
Messages: 22
Registered: July 2000
|
Junior Member |
|
|
You need to add a line to your initORCL.ora file that tells the database to bring online your rollback segments. For example:
rollback_segments = (r01, r02, r03, r04)
|
|
|
|
| Re: Rollback segment [message #50574 is a reply to message #50542] |
Fri, 22 March 2002 02:18 |
Radim
Messages: 5
Registered: March 2002
|
Junior Member |
|
|
You have to add rollback to init<ORASID>.ora, because you created rollback segment as private.
rollback_segments = ('ids_roll_priv1')
or you can create rollback as public, don't have to add entry to init.ora and the oracle brings online this rollback when it needs.
Radim
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
