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!

Oracle error message code 1653 op 4, ORA-01653: unable to extend table

545041Apr 13 2007 — edited Apr 13 2007

Hi

Our application use Oracle 9i as database. I modified one of tables and try to convert it from this application, then I got an Oralce 1653 error as followings:

Creating Table SAMPLE_T
Copying data from SAMPLE to SAMPLE_T
Unable to move data from table 'SAMPLE' to table 'SAMPLE_T'
Oracle error message code 1653 op 4, ORA-01653: unable to extend table SAND.SAMPLE_T by 1024 in tablespace SAMPLE_RESULT

I suspect the tablespace SAMPLE_RESULT is not big enough and also can not extended automatically, but not sure if it is right or there maybe other reasons behind this error.

Any idea?

Thanks

Li

Locked Post

New comments cannot be posted to this locked post.

Locked on May 11 2007

Added on Apr 13 2007

#general-database-discussions

2 comments

1,441 views