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!

ORA-1653: unable to extend table (but tablespace is not full!)

James AttardApr 12 2004 — edited Apr 12 2004
Hi folks,

I was navigating through the Alert Log file and I'm strangely noticing the error:

ORA-1653: unable to extend table PROMO.DETAILS by 40973 in tablespace PROMO

I'm defining it as strange because:
(1) The tablespace is only 65% full (there are 750MB of freespace), and
(2) There is ample space on the harddisk

I then used TOAD to try to debug the problem and there is a tool which allows me to view a map of the tablespace. I could see that the tablespace "PROMO" had indeed freespace, but the table "DETAILS" looked like it had no space where to extend (there was a table both before, and after it in the map). Is there a way to solve this problem , or isn't a problem at all?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 10 2004
Added on Apr 12 2004
11 comments
1,159 views