AnsweredAssumed Answered

Joining "Indexed" SDE Feature to Oracle Table : Join Tool Not Recognizing Index

Question asked by geonetadmin on Mar 11, 2014
Latest reply on Mar 12, 2014 by geonetadmin
Original User: ZJPierce

Hello All,

I am trying to Join an SDE layer in my mxd to an Oracle Table.

The SDE Feature is called JOINT, and the Oracle Table is called ESRI_ELEV.

I have created a unique index on the JOINT SDE feature, on the field "NUMBER1". However, when I am inside my MXD, and am in the Join Data dialogue, I get the "Message From Join" dialogue box that says: [ATTACH=CONFIG]32125[/ATTACH]. I am joining the NUMBER_1 field to EVENT_ID in the oracle ESRI_ELEV table.

From that message, it seems Arc Map is saying the SDE Number1 field is not indexed, when it is : [ATTACH=CONFIG]32126[/ATTACH].

Is there something I am missing, or I am reading this message incorrectly?