| Extent rollback segment (ora 1562) [message #53812] |
Sat, 12 October 2002 04:28  |
M. Oudeman
Messages: 4
Registered: October 2002
|
Junior Member |
|
|
I get "ORA-01562: failed to extend rollback segment number" when trying to perform a operation.
The actual RB-egment has a max_extend of 121.
I tried to alter this:
"SQL> alter rollback segment rb1 storage (maxextents 1000);"
But then I get:
"ORA-01681: Parameter unlimited_rollback_segments must be set to TRUE for this operation
ORA-02226: invalid MAXEXTENTS value (max allowed: 121)"
Does anyone know what I should do now?
Thanks.
|
|
|
|
|
|
| Re: Extent rollback segment (ora 1562) [message #53820 is a reply to message #53815] |
Sun, 13 October 2002 20:35  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
Here is what the docs are telling us:
Parameter: UNLIMITED_ROLLBACK_SEGMENTS
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Parameter type: string
Default value: FALSE
Range of values: TRUE / FALSE
Description:
~~~~~~~~~~~~
This must be set to TRUE to use UNLIMITED EXTENT FORMAT blocks for rollback segments. Eg: If MAXEXTENTS for the DB has a max value of 121 (2K block size) then to use a storage clause with MAXEXTENTS higher than this requires this parameter be set to TRUE.
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
|
|
|
|
| Re: Extent rollback segment (ora 1562) [message #53878 is a reply to message #53820] |
Tue, 15 October 2002 11:49 |
M. Oudeman
Messages: 4
Registered: October 2002
|
Junior Member |
|
|
This is tougher than you think.
I searched my machine and found that I do not have a ora.init file.
I did place a txt-file in the Ora95/bin (and ora95/database directory (in this directory the datafile are located) and started the instance but did not help.
I am running a personal oracle database version 7.3.4.
Do you have clues where I should put this file?
|
|
|
|
| Re: Extent rollback segment (ora 1562) [message #53882 is a reply to message #53820] |
Tue, 15 October 2002 21:39 |
M. Oudeman
Messages: 4
Registered: October 2002
|
Junior Member |
|
|
This is tougher than you think.
I searched my machine and found that I do not have a ora.init file.
I did place a txt-file in the Ora95/bin (and ora95/database directory (in this directory the datafile are located) and started the instance but did not help.
I am running a personal oracle database version 7.3.4.
Do you have clues where I should put this file?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
