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

855585Apr 15 2011 — edited Apr 20 2011

Hi,
I have received below error.
ORA-1653: unable to extend table test by 8192 in tablespace test1

DB : oracle 9i
OS : windows 2003

my test1 tablespace size is 111 GB and 2GB freespace also ther with 50 datafiles. and also all datafiles are in autoextend on. mentioned test table have
18863500 records and table size is 64 GB.

can any one tell me what ll be the problem, is there any limit for tables size ?

Locked Post

New comments cannot be posted to this locked post.

Locked on May 18 2011

Added on Apr 15 2011

#general-database-discussions

8 comments

1,069 views