size of temp segment?

Hi,

I am trying to do some tests on Oracle Intermedia, but I am unable to get my table indexed.

I have a table consisting simply of two columns, a text document and its associated reference number. There are currently around 280,000 documents (rows) in the table which amount to about 1.5 GB of text (don't know about the table size right now). I will need to work with at least three times that amount of data.

Now, when I run "create index TEST_INDEX on TEST(text) indextype is ctxsys.context" it fails, apparently because of underdimensioned tablespaces (some of which got resolved by adding files to the tablespace). The latest one is (using DBD::Oracle from Perl):

| DBD::Oracle::st execute failed: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
| ORA-20000: interMedia Text error:
| DRG-50857: oracle error in drixtab.create_index_indexes
| ORA-01652: unable to extend temp segment by 18208 in tablespace DRSYS
| ORA-06512: at "CTXSYS.DRUE", line 126
| ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 78
| ORA-06512: at line 1 (DBD ERROR: OCIStmtExecute) at ./dbi_index.pl line 8.

I am not an Oracle admin and the person in charge tells me that DRSYS is already pretty big (a few GB, and autoextend) and he's uneasy about making it bigger (done it a few times already).

Would adding files to tablespace DRSYS (and making sure there's space on the partition) solve the problem? How can I determine the parameters to make it work?

I can issue sql commands as the database manager, so I should be able to get any additional info that would be helpful. I am currently working with Oracle 8i (Linux) but I could switch to a different server we have with Oracle 9 (Windows).

Ciao,

   Jens Received on Fri Feb 28 2003 - 04:54:04 CST