Hi,

I'm having a strange problem on a 8.1.7.1 database. We are doing once a day optimization of text-indexes. We do this by the ctx_scheduling package every day at the evening (normally no users are working than).

but get next errors in my alertlog:
ora-12012: error on auto execute of job 1
ora-20000: intermedia text error
drg-50857: oracle errro in dreogc
ora-00600: with argument [6033]
ora-06512: at ctxsys.drue at line ...
ora-06512: at ctxsys.ctx_ddl at line ...

I also saw that in dba_jobs, the first job had 2 failures.
We also do optimizing of 2 other indexes, this runs well. (maybe less documents - changes could be the reason).

Today I tried to run the ctx_ddl.optimize_index('index_name','optimize full') direct on the prompt (not by schedule), but this is already running now for more than 6 hours???!

I don't find anything about this problem on google, metalink ...
Only at metalink there was a bug that has almost same problems as mine, but they don't really give a solution :-(

Should I upgrade to 8.1.7.3 or later? Upgrading to 9i is not an option at this moment ...

Also on Oracle 9.2.0.4 we use exact the same procedures and this runs without problems...

anyone else who had this problem and could help me out with this?
thanks

8.1.7.1 is very very old Oracle software nowadays (especially since you haven't apply any patches to it). I would try to patch it -- but.. before, make sure you make a backup in case you have to restore everything to where it was before it.

Hi,

I was able to patch it to 8.1.7.3 and problem seems to be solved now...
thanks