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

533779Apr 10 2009 — edited Apr 20 2009

Hi All,

DB-10.2.0.3

I got following lines in Alert log and when I checked the corrosponding tablespace, it showed me sufficient space.

=================
TABLESPACE                     ACT_SIZE       FREE_MB   %FREE       USED_MB   %USED LARGEST_EXTENT_MB
------------------------- ------------- ------------- ------- ------------- ------- -----------------
USERS                          1,802.00      1,034.13   57.39        767.88   42.61            159.13
================

MAX_EXTENTS NEXT_EXTENT MIN_EXTENTS INITIAL_EXTENT PCT_INCREASE
----------- ----------- ----------- -------------- ------------
2147483645      131072           1         131072            0

Tell me one thing, it got failed becuse of next extent won't able to hold the space request. or anything else, which caused this error to happen. I would also appriciate, if someone can come up and make me understand in detail.
May be with some exapmles.

hare krishna

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 18 2009
Added on Apr 10 2009
16 comments
3,743 views