topic ORA-00972: identifier is too long when using Make Query table tool in Data Management Questions https://community.esri.com/t5/data-management-questions/ora-00972-identifier-is-too-long-when-using-make/m-p/485675#M27613 <HTML><HEAD></HEAD><BODY><SPAN>Dear all</SPAN><BR /><BR /><SPAN>I am trying to create a view on an SDE using the make query table tool. However I keep getting:</SPAN><BR /><BR /><SPAN>ORA-00972: identifier is too long when I type in the SQL expression.</SPAN><BR /><BR /><SPAN>so "SDE.XXX_XXXX_XXXX_XXX_XXXXXX.XXXX" = "SDE.XXXXXXX_XXXXXXX_XXXXXXX_XXX.XXXXXX_XXXX".</SPAN><BR /><BR /><SPAN>If I don't put the names in " " then I get ORA-00904: "field name in here": invalid identifier.</SPAN><BR /><BR /><SPAN>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.</SPAN><BR /><BR /><SPAN>I am using ArcMap 10.0.2 and connecting to ArcSDE 9.3 running I believe Oracle 10g</SPAN><BR /><BR /><SPAN>Kind regards</SPAN><BR /><BR /><SPAN>Tim</SPAN></BODY></HTML> Tue, 17 May 2011 10:11:56 GMT TimLangner 2011-05-17T10:11:56Z ORA-00972: identifier is too long when using Make Query table tool https://community.esri.com/t5/data-management-questions/ora-00972-identifier-is-too-long-when-using-make/m-p/485675#M27613 <HTML><HEAD></HEAD><BODY><SPAN>Dear all</SPAN><BR /><BR /><SPAN>I am trying to create a view on an SDE using the make query table tool. However I keep getting:</SPAN><BR /><BR /><SPAN>ORA-00972: identifier is too long when I type in the SQL expression.</SPAN><BR /><BR /><SPAN>so "SDE.XXX_XXXX_XXXX_XXX_XXXXXX.XXXX" = "SDE.XXXXXXX_XXXXXXX_XXXXXXX_XXX.XXXXXX_XXXX".</SPAN><BR /><BR /><SPAN>If I don't put the names in " " then I get ORA-00904: "field name in here": invalid identifier.</SPAN><BR /><BR /><SPAN>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.</SPAN><BR /><BR /><SPAN>I am using ArcMap 10.0.2 and connecting to ArcSDE 9.3 running I believe Oracle 10g</SPAN><BR /><BR /><SPAN>Kind regards</SPAN><BR /><BR /><SPAN>Tim</SPAN></BODY></HTML> Tue, 17 May 2011 10:11:56 GMT https://community.esri.com/t5/data-management-questions/ora-00972-identifier-is-too-long-when-using-make/m-p/485675#M27613 TimLangner 2011-05-17T10:11:56Z