Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

INITIAL, NEXT .. MAXEXTENTS, MINEXTENTS????

583343Nov 27 2008 — edited Nov 27 2008
HI

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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 25 2008
Added on Nov 27 2008
6 comments
2,892 views