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
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.
OCP DBA 8i, 9i, 10g
Click Here to Expand Forum to Full Width