Re: SET TRANSACTION .. didn't work

Looking more closely, it gets worse -

>> > >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

It looks as if your filesystem was unable to meet the demand for a file autoextend (even though it was quite a small file)

It is interesting that 'create intermedia index' generates so much rollback - the 'extensibility option' isn't quite as transparent as one might hope - 'create index' for normal data doesn't require very much rollback at all.

I haven't used the context option since 7.3, but there was some ctxsys parameter that could be used to change the amount of memory allocated for building context indexes - if this is still possible for Intermedia then a larger in-memory build might reduce the amount of rollback generated on the build, since I guess the rollback appears from updates as index sections are merged.

Also, is there a 'nologging' option with intermedia index build ? For normal data, this is irrelevant for rollback purposes, but perhaps for intermedia it would have some side-effect on rollback.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases

Publishers:                 Addison Wesley Longman
Book bound date:     8th Dec 2000
See a first review at:
http://www.ixora.com.au/resources/index.htm#practical_8i

Vadim Grepan wrote in message <3A139B49.1464173C_at_mail.ru>...


>Hello Mark!

 Thanks. Of course I've seen this error message too :)  I need real LARGE


>"temporary"rollback which I'll drop after creating index. If I increase

>"permanent" rollback datafile I cannot decrease it back.

>

>Rgds, Vadim Grepan

>----------------------------

>Moscow, Russia

>

>