topic Re: Support for Oracle 11g in State & Local Government Questions https://community.esri.com/t5/state-local-government-questions/support-for-oracle-11g/m-p/556090#M3598 <HTML><HEAD></HEAD><BODY><SPAN>Hi Ronnie, </SPAN><BR /><BR /><SPAN>We, ArcGIS for Local Government support Oracle 11G. We are aware of this issue and are working toward fixing it in the coming release.</SPAN><BR /><BR /><SPAN>The failures you are seeing on import are on the following items:</SPAN><BR /><UL><BR /><LI>luCodeViolationInspection_ATTACH</LI><BR /><LI>DamageResidentialBuilding_ATTACH</LI><BR /><LI>WaterDistribution_Net_Junctions</LI><BR /></UL><BR /><SPAN>You'll notice that issues exist with table items which add additional characters upon creation. </SPAN><BR /><BR /><SPAN>To workaround the issue you are describing, remove the attachment from the: </SPAN><BR /><UL><BR /><LI>luCodeViolationInspection</LI><BR /><LI>DamageResidentialBuilding</LI></UL><SPAN>feature classes. (Using "delete attachments" ) </SPAN><BR /><BR /><SPAN>Rename the features classes to:</SPAN><BR /><UL><BR /><LI>luCodeViolateInspect</LI><BR /><LI>DamageResBuilding</LI></UL><SPAN>The recreate the attachments (using "create attachments")</SPAN><BR /><BR /><SPAN>As for the WaterDistribution_NET_JUNCTIONS, recreate the network using the word Water, this will shorten the table name length significantly.</SPAN><BR /><BR /><SPAN>Cheers,</SPAN><BR /><SPAN>Lindsay</SPAN></BODY></HTML> Fri, 11 Jan 2013 20:41:56 GMT LindsayThomas 2013-01-11T20:41:56Z Support for Oracle 11g https://community.esri.com/t5/state-local-government-questions/support-for-oracle-11g/m-p/556089#M3597 <HTML><HEAD></HEAD><BODY><SPAN>Hi All,</SPAN><BR /><SPAN>We want to use the Local Government model in our Oracle 11g Database but I get errors regarding Tablename length because there are tables in the Model with names longer than 29 characters.</SPAN><BR /><BR /><SPAN>Does this mean the model does not support Oracle?</SPAN><BR /><BR /><SPAN>Thanks </SPAN><BR /><SPAN>Ronnie</SPAN></BODY></HTML> Sat, 22 Dec 2012 00:21:32 GMT https://community.esri.com/t5/state-local-government-questions/support-for-oracle-11g/m-p/556089#M3597 RonnieSteyn 2012-12-22T00:21:32Z Re: Support for Oracle 11g https://community.esri.com/t5/state-local-government-questions/support-for-oracle-11g/m-p/556090#M3598 <HTML><HEAD></HEAD><BODY><SPAN>Hi Ronnie, </SPAN><BR /><BR /><SPAN>We, ArcGIS for Local Government support Oracle 11G. We are aware of this issue and are working toward fixing it in the coming release.</SPAN><BR /><BR /><SPAN>The failures you are seeing on import are on the following items:</SPAN><BR /><UL><BR /><LI>luCodeViolationInspection_ATTACH</LI><BR /><LI>DamageResidentialBuilding_ATTACH</LI><BR /><LI>WaterDistribution_Net_Junctions</LI><BR /></UL><BR /><SPAN>You'll notice that issues exist with table items which add additional characters upon creation. </SPAN><BR /><BR /><SPAN>To workaround the issue you are describing, remove the attachment from the: </SPAN><BR /><UL><BR /><LI>luCodeViolationInspection</LI><BR /><LI>DamageResidentialBuilding</LI></UL><SPAN>feature classes. (Using "delete attachments" ) </SPAN><BR /><BR /><SPAN>Rename the features classes to:</SPAN><BR /><UL><BR /><LI>luCodeViolateInspect</LI><BR /><LI>DamageResBuilding</LI></UL><SPAN>The recreate the attachments (using "create attachments")</SPAN><BR /><BR /><SPAN>As for the WaterDistribution_NET_JUNCTIONS, recreate the network using the word Water, this will shorten the table name length significantly.</SPAN><BR /><BR /><SPAN>Cheers,</SPAN><BR /><SPAN>Lindsay</SPAN></BODY></HTML> Fri, 11 Jan 2013 20:41:56 GMT https://community.esri.com/t5/state-local-government-questions/support-for-oracle-11g/m-p/556090#M3598 LindsayThomas 2013-01-11T20:41:56Z