ORA-00972: identifier is too long when using Make Query table tool

3441
0
05-17-2011 03:11 AM
TimLangner
Occasional Contributor III
Dear all

I am trying to create a view on an SDE using the make query table tool. However I keep getting:

ORA-00972: identifier is too long when I type in the SQL expression.

so "SDE.XXX_XXXX_XXXX_XXX_XXXXXX.XXXX" = "SDE.XXXXXXX_XXXXXXX_XXXXXXX_XXX.XXXXXX_XXXX".

If I don't put the names in " " then I get ORA-00904: "field name in here": invalid identifier.

I realise that the identify name has to be under 31 characters but even when I enter an alias beside the fields names in the make query table, it doesn't make use of those for the SQL expression.

I am using ArcMap 10.0.2 and connecting to ArcSDE 9.3 running I believe Oracle 10g

Kind regards

Tim
0 Kudos
0 Replies