1 Reply Latest reply: Nov 15, 2012 11:05 AM by Ebalthes-Oracle RSS

    Creating Text Index fails with ORA-01652

    anca
      Hello all,

      we have a file data store with ca. 300.000 documents which we want to index.
      We've set P_TABLE_CLAUSE to a tablespace 'my_ctx_idx' which can grow up to 60GB.

      The index creation fails after almost 2 days, in status POPULATE_P, with the following error (sorry, german):
      ORA-29855: Fehler bei Ausführung der Routine ODCIINDEXCREATE
      ORA-20000: Oracle Text error:
      DRG-50857: oracle error in drvxtab.populate_ptable
      ORA-01652: Temp-Segment kann nicht um 128 in Tablespace TEMP erweitert werden
      ORA-06512: in "CTXSYS.DRUE", Zeile 160
      ORA-06512: in "CTXSYS.TEXTINDEXMETHODS", Zeile 366

      which means it cannot extend the tablespace TEMP while populate_ptable.

      The $I table is 26GB, $X is 7GB.

      So, my questions:
      1. why does it need space on TEMP if P_TABLE_CLAUSE ist set to something else and
      2. how big should I tell the DB Admin to set the TEMP Tablespace?

      Tanks for any help,
      Anca