-
Maxextents are not valid in the case of locally managed tablespaces and hence on the objects in the tablespace. So if you try it on objects belonging to LMT you will get
alter table rd_towns storage (maxextents unlimited)
*
ERROR at line 1:
ORA-25150: ALTERING of extent parameters not permitted
Amar
"There is a difference between knowing the path and walking the path."
-
Originally posted by adewri
alter table rd_towns storage (maxextents unlimited)
*
ERROR at line 1:
ORA-25150: ALTERING of extent parameters not permitted
Actaully, on LMT's the DEFAULT is ulimited, and you can set a segment's maxextents residing in a LMT, but it is ignored. I think I proved this a couple of weeks ago in another thread.
OCP 8i, 9i DBA
Brisbane Australia
-
-
Originally posted by adewri
and now you got the reason also, why not to try to change the maxextents for LMT segments.
Because it's ignored.
OCP 8i, 9i DBA
Brisbane Australia
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
|