-
Hi
when i am creating rollback segments its giving a problem
ORA-01681: Parameter unlimited_rollback_segments must be set to TRUE for this operation
Were i need to change this parameter and so on .
Thanks
lnreddy
html code is off
-
Change max number of extents for the ROllback to unlimited.
-
hI
YEAH I TOO GOT THE SAME PROBLEM (because i made the maxextents unlimited)
So i made the maxextents 121 instead unlimited then it worked fine
Thanks
Ravi
ravi
-
in 7.3 and 8.0 (i think) you had to set the init.ora parameter unlimited_rollback_segments to true *before* you could set the maxextents for a rbs to unlimited. i don't know if you could do any alter system, but i think it required a database bounce. sorry to be a bit vague; it's been a while since i've worked in 7.3 or 8.0
d.
-
hi ravi ,
After i changed that its doing fine for me .
u have any idea what is the reason for that .
Thanks for that
Thanks
lnr
html code is off
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|