How to resize table initial size? - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: How to resize table initial size?

  1. #11
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Originally posted by jovery

    Why do you want to move the data to a single extent?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  2. #12
    Join Date
    Jun 2003
    Posts
    2

    Isn't 1 extent better for performance reasons?

    Isn't 1 extent better for performance reasons?

  3. #13
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865

    Re: Isn't 1 extent better for performance reasons?

    Originally posted by ayeleta
    Isn't 1 extent better for performance reasons?
    Can you elaborate on that ?

  4. #14
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  5. #15
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Originally posted by ArlynSmith
    Simply use an 'alter table move...' and specify a new storage clause, including a new intial extent. You do not have to move the table to a new tablespace - if you do not specify a tablespace it will be moved to a new extent in the same tablespace. This will preserve your constraints, indexes, and permissions.
    I think you will need to recreate the indexes - the rowid's will have changed.

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