AnsweredAssumed Answered

Database spatial enabled view from NonSpatial Database

Question asked by abdullah.saleh on Feb 7, 2016
Latest reply on Feb 8, 2016 by vangelo-esristaff

Greetings All,


My Environment: ArcSDE 10.1, Linux RHEL 6, Oracle 11g2


In our environment we have a two corporate databases Database1(non-spatial) and Database 2(geodatabase). Database 1(non-spatial) has a table TAB1 with geometry column and it gets continiously updated. I want to create a spatially enabled view in DATABASE2(geodatabase) of this table to get updates simultaneously to our GIS users using Database2(geodatabase).
Please help me with the best way to do this.


My Homework: In DATABASE2 .. I created oracle view .. registered it as layer, but it failed to draw geography in ArcMap with message"Spatial Index needed". It once again failed when i tried to create spatial index on the view.