SET TRANSACTION .. didn't work

From: Vadim Grepan <kezal_at_mail.ru>
Date: Wed, 15 Nov 2000 10:25:07 +0300
Message-ID: <3A123A53.70BC8D99@mail.ru>

Hello!

   I need to create large interMedia index so I've decided to use additional rollback segment (
  placed on separate datafile) But SET TRANSACTION .. didn't assign required rollback.
  What would it be? Oracle 8.1.6 on SUN Sparc.

= = cut = = = SQL> SET TRANSACTION USE ROLLBACK SEGMENT RBS_INDEX_TMP;

Transaction set.

SQL>
SQL> create index NDX_MSG_CONTENT on tbl_msg(msg_CONTENT) 2 indextype is ctxsys.context
3 ');

create index NDX_MSG_CONTENT on tbl_msg(msg_CONTENT) *
ERROR at line 1:

ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: interMedia Text error:
DRG-50857: oracle error in dreiiflush
ORA-01562: failed to extend rollback segment number 5
ORA-01237: cannot extend datafile 6
ORA-01110: data file 6: '/dsk1/s1/oradata/EL83/rbs01.dbf'
ORA-19502: write error on file "/dsk1/s1/oradata/EL83/rbs01.dbf",

blockno 2419
= = = cut = = =

Rgds, Vadim Grepam

Moscow, Russia Received on Wed Nov 15 2000 - 01:25:07 CST