topic Can ArcSDE for Oracle be configured to use varchar2 (not nvarchar2) for text columns? in Data Management Questions

Can ArcSDE for Oracle be configured to use varchar2 (not nvarchar2) for text columns?

NathanielWingfield — Thu, 08 Apr 2010 15:13:04 GMT

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?

Can ArcSDE for Oracle be configured to use varchar2 (not nvarchar2) for text columns?

VinceAngelo — Thu, 08 Apr 2010 15:40:08 GMT

Yes -- http://support.esri.com/index.cfm?fa=knowledgebase.techarticles.articleShow&d=36459

- V

Can ArcSDE for Oracle be configured to use varchar2 (not nvarchar2) for text columns?

NathanielWingfield — Thu, 08 Apr 2010 16:59:22 GMT

That worked great, thanks.

Re: Can ArcSDE for Oracle be configured to use varchar2 (not nvarchar2) for text colu

BillHarvey — Thu, 28 Jun 2012 17:34:15 GMT

That worked great, thanks.

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?

Thanks very much.
Bill