INITIAL, NEXT .. MAXEXTENTS, MINEXTENTS????
583343Nov 27 2008 — edited Nov 27 2008HI
One of our database table has reached maxextents and I am not able to insert new rows in this table.
The Storage parameters used while creating this table are as follows: -
TABLESPACE ABCD_3
PCTUSED 40
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 56K
NEXT 8K
MINEXTENTS 1
MAXEXTENTS 121
PCTINCREASE 0
FREELISTS 1
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
)
LOGGING
NOCACHE
NOPARALLEL;
I have a some doubts ...
1. What is the difference between an EXTENT and a BLOCK?
2. The sizes mentioned here ... 56K, 8K etc ... Does this mean that we have 56 blocks/8 Blocks or 56 KB/8KB?
3. Here we have 56K but also we have MINEXTENTS as 1!!!!
So what was the initial size of my table then??? I am confused between INITIAL and MINEXTENTS.
4. NEXT is 8K. Does that mean that whenever my current extent gets filled up completely then I will be allocated an extent of 8K each time???
5. MAXEXTENT has reached and now I am unable to insert any rows now.
I am planning to rename my existing table .... Create a new table .... Insert the data back and delete the renamed table.
How can I analyze my table and the data in it so that I can achieve a better understanding of correct storage parameters.