Community
Select to view content in your preferred language

Support for Oracle 11g

1560
1
12-21-2012 04:21 PM
Labels (1)
Labels
RonnieSteyn
by
New Contributor
‎12-21-2012 04:21 PM
Hi All,
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.

Does this mean the model does not support Oracle?

Thanks
Ronnie
0 Kudos
1 Reply
LindsayThomas
by Esri Contributor
Esri Contributor
‎01-11-2013 12:41 PM
Hi Ronnie,

We, ArcGIS for Local Government support Oracle 11G. We are aware of this issue and are working toward fixing it in the coming release.

The failures you are seeing on import are on the following items:

  • luCodeViolationInspection_ATTACH

  • DamageResidentialBuilding_ATTACH

  • WaterDistribution_Net_Junctions


You'll notice that issues exist with table items which add additional characters upon creation.

To workaround the issue you are describing, remove the attachment from the:

  • luCodeViolationInspection

  • DamageResidentialBuilding
feature classes. (Using "delete attachments" )

Rename the features classes to:

  • luCodeViolateInspect

  • DamageResBuilding
The recreate the attachments (using "create attachments")

As for the WaterDistribution_NET_JUNCTIONS, recreate the network using the word Water, this will shorten the table name length significantly.

Cheers,
Lindsay
0 Kudos