This discussion is archived
1 Reply Latest reply: Nov 15, 2012 9:05 AM by ebalthes RSS

Creating Text Index fails with ORA-01652

user180488 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points