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