Database Software

Hi all,

In Oracle 11.2.0.2 environment (RedHat 5) I have a situation with text indexing for files that reside on a filesystem ...over 700 G of documents, some of them relatively huge.

This is my case:

- During text index creation /tmp partition gets filled up pretty quickly and 'ctxhx' process times-out;
- I think I understand that 'ctxhx' process uses /tmp space (default Oracle owner's temp space) to 'filter' files and creates text files before creating tokens, etc ...;
- My workaround was to change temporary space for oracle owner by setting 'TMP','TMPDIR' and 'TEMP' variables to point to partition where more space available ... it worked fine, the index was successfully created and I reverted temp space back to /tmp when the index was created;
- Now when I synchronize my index with baseline table content (new files), from time to time, I get /tmp available space exhausted ... the index gets synchronized but I don't like to have other oracle processes suffering because of this;

The question is: is there any way to tell Oracle to use specific 'tmp' location for text index creation/sync process (ctxhx process) only and not oracle owner's default space. I also don't want to increase /tmp space or use another 'tmp' partition for entire database (that would require too much testing that I can't afford now).

Any idea would be highly appreciated.

Thanks.