Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Location
    Belgium
    Posts
    48

    Unhappy Unanswered: ctx_ddl.optimize_index gives errors

    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

  2. #2
    Join Date
    May 2004
    Location
    Dominican Republic
    Posts
    721
    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.

  3. #3
    Join Date
    Dec 2003
    Location
    Belgium
    Posts
    48

    Thumbs up

    Hi,

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •