1 Reply Latest reply on Mar 6, 2009 7:35 AM by lnim-Oracle

    ORA-29902: error in executing ODCIIndexStart() routine

    676740
      I am getting an ODCIIndexStart() routine error, on executing the following query.

      SQL> select * from TM_4422319 where COL4 = to_date('5/8/9999 8:24:7', 'DD/MM/YY HH:MI:SS');
      select * from TM_4422319 where COL4 = to_date('5/8/9999 8:24:7', 'DD/MM/YY HH:MI:SS')
      *
      ERROR at line 1:
      ORA-29902: error in executing ODCIIndexStart() routine
      ORA-29400: data cartridge error
      INTERNAL ERROR ING-555. Refer to log file for more information.
      [01] IngIdxStartDateByName: failed to get column encryption parameters.
      [00] IngIdxGetColumnEncryptionParams: failed to read meta data for
      QATEST.TM_4422319_NEW(COL4_NEW).

      Not able to understand what is wrong with it.