DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: next extent

  1. #1
    Join Date
    Jan 2001
    Posts
    138
    One of our tables has size of 47,240 kb. Initial extent is 6156 kb, next extent is 40,960 kb. So, one more extent is available. I added 500 MB more space to the datafile. Should I reduce the next extent to say 4096 kb, so we don't get out of extents error?

    TEMP_RL_PC_HOLD T TS_TEMP_DATA01 47,240 40,960 1

  2. #2
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    I am not sure I understand your question, but consider this solution.

    If you have room in your tablespace or you have another tablespace, try resizing the table and putting all the data into one extent.

    First move it to another tablespace and then move it back.

    ALTER TABLE tablename
    MOVE TABLESPACE newtablespace
    STORAGE (initial ... next ...);

    If you size your initial extent to be larger and your growth rate is not too rapid, you can keep track of which tables are growing, and resize them as needed.

    Good luck.
    David Knight
    OCP DBA 8i, 9i, 10g

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