Context Option: Why do ctx_dml.reindex fail?

I have now spent a lot of time trying to get the reindex procedure of the Context option to work (Context 2.0.6 on Oracle 8.0.4 on Win NT) and appreciate any help.

I have created a policy 'dlctxpol' as user 'DBO' (after 'grant ctxadmin to DBO'). This works fine. E.g. the user 'KAH' are able to make selects containing the 'contains' function (after 'grant ctxuser to KAH').

The user 'DBO' (a user who has got DBA privileges) are able to execute the following statement:

    execute ctx_dml.reindex('dbo.dlctxpol','1');

When the user 'KAH' tries to execute the reindex he gets the following:

    ORA-20000: ConText error:
    ORA-20000: ConText error:
    DRG-10502: Unknown message id 10502
    ORA-06512: ved "CTXSYS.DRUE", linje 180
    ORA-06512: ved "CTXSYS.CTX_DML", linje 193
    ORA-06512: ved linje 2

I have tried to grant almost everything to the user 'KAH' but without luck (granted ctxadmin, granted execute on ctx_dml, ctx_admin ..., ). The only exception is that it works if i grant DBA to KAH. There must be another way to do it. Any hints are appreciated.

Regards
Kasper Hansen Received on Sat Oct 10 1998 - 12:40:20 CDT