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?

Locked Post

New comments cannot be posted to this locked post.

Locked on May 10 2004

Added on Apr 12 2004

#general-database-discussions

11 comments

1,161 views