14 Replies Latest reply on Aug 24, 2012 3:52 PM by jgarry

    unable to extend index <name of the index> by 8 in tablespace

    798692
      Hello,

      I am not a DBA and do not have much experience in Oracle. When I was trying to restore the backup of my application, I received the following error. I could not able to proceed further in my tasks.
      ORA-01654: unable to extend index <name of the index> by 8 in tablespace <name of the Index tablespace>
      The following query was used to create the table space. Oracle version is 10g.
      CREATE TABLESPACE TS_JIRA
      DATAFILE 'D:\oracle\product\10.2.0\oradata\jiraadmi\TS_JIRA.dbf' SIZE 100M REUSE 
      AUTOEXTEND ON NEXT 10M MAXSIZE 200M
      MINIMUM EXTENT 64K
      DEFAULT STORAGE ( INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0);
      I do not know how to extend the size of the tablespace. Can anyone help to sort out this issue?

      Thanks in advance
      Ram