Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2006
    Posts
    5

    Unanswered: creating new extents

    I have a table that has grown to the size of my dbspace, how do I create the next extent for that table in a different dbspace.

    Thanks

    Andrus

  2. #2
    Join Date
    May 2004
    Location
    New York
    Posts
    248
    Either increase the size of your dbspace or look into fragmentation across multiple dbspaces.

  3. #3
    Join Date
    Jan 2006
    Posts
    5
    Hi

    Thanks, but I still dont know how to do it. I cant increase the size as it is at its maximum - 2GB

  4. #4
    Join Date
    Apr 2003
    Location
    Phoenix, AZ
    Posts
    177
    You can add a chunck to the existing dbspace and the table will extend into the additional chunck(s).
    Fred Prose

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •