max extents reached - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: max extents reached

  1. #11
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    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."

    Amar's Blog  Get Firefox!

  2. #12
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    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

  3. #13
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796

    Thumbs up

    Originally posted by grjohnson
    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.
    and now you got the reason also, why not to try to change the maxextents for LMT segments.
    Last edited by adewri; 01-30-2003 at 03:30 AM.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  4. #14
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    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
  •  



Click Here to Expand Forum to Full Width