Alter table - next extent
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Alter table - next extent

  1. #1
    Join Date
    Sep 2001
    Posts
    13

    Question Alter table - next extent

    I have a rather large table (19,000,000 million rows = 7 gig). I need to alter the next extent size, as it is too large (.5 gig). I do not have that much contiguous free space in this file system. So, I plan:

    alter table GLTRANS
    storage (next 250M);

    Does that sound okay?
    Does the database have to be offline or can the users still be accessing it?
    Does this come back quick, or is it going to try to dump and reload all the records?

    Thanks in advance,
    DJ

  2. #2
    Join Date
    Jan 2003
    Location
    Belgium
    Posts
    1
    DJ,

    Yes, you can perfectly adjust the next extent size of an object only whithout effecting anyone.

    The change will be immediat

    Hope this helps

  3. #3
    Join Date
    Jul 2000
    Posts
    119
    Is your tablespace in which this table resides is locally managed ?If it's then why bother ? If it's not then ofcourse you can go ahead with this option!
    OCP 8.0, 8i, 9i

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