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

mirmadJul 9 2006 — edited Jul 10 2006

hi guys!
its the second time am posting this message! had this error in this alert.log
ORA-1653: unable to extend table APPLSYS.WF_LOCAL_ROLES_STAGE by 4849950 in tablespace APPLSYSD

the tablespace is APPLSYSD free_space 59390.4688M used_space 22495.7031M

initial extent 40960, next_extent 1048576, max_extent 2147483645 and pct_free is set to 0!
the tablespace contains three datafiles and their percentage used is 36%, 35% and 12%. I dont really understand how this error comes! how come in the error, it wants to extend by 4849950 while the value for next_extent is 1048576? could some one please help me overcome this problem??

Thanls

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 7 2006

Added on Jul 9 2006

#general-database-discussions

16 comments

816 views