| ORA-01681, ORA-02226 [message #55488] |
Mon, 27 January 2003 10:30  |
Carlos Olmeda
Messages: 22
Registered: January 2003
|
Junior Member |
|
|
Good Afternoon,
Im trying to create tablespaces and also trying to resize my datafiles. However I continue to recieve this error.
ORA-01681: parameter unlimited_rollback_segments must be set to true for this operation
ORA-02226 -invalid MAXEXTENTS value (max allowed:121)
where do I modify these settings?...in the init.ora file?
|
|
|
|
| Re: ORA-01681, ORA-02226 [message #55498 is a reply to message #55488] |
Mon, 27 January 2003 17:10  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
This is 7.3.4 parameter in init.ora file. Add or modify this parameter to true, restart the db afterwards.
Then check it's value:
SQL>select name, value from v$parameter where name= 'unlimited_rollback_segments';
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
