By default, ArcSDE 9.3 for Oracle now uses the nvarchar2 type for text columns. My app requires an Oracle Text CTXCAT index, which is not supported on nvarchar2 fields. Can ArcSDE be configured to use varchar2 instead?
This is an older post, so hopefully you still get emails. I am using a ctxcat index on our stuff too. Two questions: 1)With CTXCAT indexes you don't have to do ctx_ddl.sync_indexes because they are done automatically during DML operations. However, Oracle documentation states: "Applications that insert without invoking triggers such as SQL*Loader will not result in automatic index synchronization as described...." I am inserting into the table (non-versioned) with ArcObjects code. Do you reckon ArcObjects inserts will still allow the auto synch, or will I have to do it manually? 2) Do you run ctx_ddl.optimize_index? Again, if the CTXCAT index syncs automatically, do you have to run optimize?
