We have a very complicated setup for a project we are doing, and it involves 40+ developers and two oracle databases, one with sde and one only with oracle spatial and it's quite big.
We'll here are my issues:
In the SDE database, ArcSDE is creating my linear tables as Linestrings, while in the other Oracle database, we have Multilinestring tables. I'm not sure how that got by, and there is a ton of code built on top of the oracle only schema.
How can I transform a simple linestring in a multilinestring? Here is what we've tried:
- Using oracle append function to see if it returned a multi* geometric field. it does return a multi* geometry, but some parameters in the metadata are different
- using sdelayer -o delete and sdelayer -o register to force a multilinestring. The procedure was fine, but even after new inserts, the oracle db is still seeing linestrings.
- Merging two geometries inside arcgis. Still linesting geometry.
Any thoughts? Hacks? Solutions?
Changing the datamodel or code, specially code inside our oracle only db is an issue. Not possible.
Thanks for your attention and insights!