5 Replies Latest reply: Mar 8, 2008 5:19 AM by Sabdar Syed RSS

    ORA-01653 unable to extend table.

    614419
      Hi All,

      I am Using oracle 9i on Windows XP box

      I got the following error messages .
      ORA-01653: unable to extend table SCOTT.EMP2 by 128 in tablespace ORADATA

      I was inserting 557056 rows from emp table to emp2 table , by issuing

      sql> insert into emp2 select * from emp ;

      My emp2 table is in tablespace oradata which I created by issuing.

      create tablespace oradata
      datafile 'c:\oratemp\data01.dbf' size 20m
      extent management local
      autoallocate
      segment space management auto

      Please help me to explain why I got this error and how to solve this error.

      Thanks.