Help With Spatial Views in Oracle

4343
13
Jump to solution
06-17-2015 03:13 PM
DavidYamamoto
New Contributor

Hello Kind People. I'm trying to create a database view in Oracle, joining polygon feature class in the geodatabase to an attribute table. I'm using the ArcCatalog tool Data Management Tools --> General --> Create Database View. I specify all of the input parameters, including the SQL to define the view. I'm including the OBJECTID and SHAPE field from the feature class. The tool runs fine, but when I look at the view in Catalog, it's just a data table. The SHAPE column is of type LONG. I thought I should be able to load the view up in ArcMap and see the geometries. Am I misssing something here? Than you very much in advance for any and all assistance. David

0 Kudos
13 Replies
DavidYamamoto
New Contributor

Hi Sam. Okay, will do. By the way, is there a special license level for the Data Management-->Database toolset? I don't see it in Catalog.

0 Kudos
DavidYamamoto
New Contributor

I found it! It's different in 10.3

Data Management-->Geodatabase Administrattion-->Mirgrate Storage

Sorry about that.

0 Kudos
DavidYamamoto
New Contributor

Hi Sam. I used the Migrate Storage tool to change the geometry storage type, created the view, AND IT WORKED! You've been very helpful. I can't thank you enough. David

0 Kudos
SamuelTompsett
Occasional Contributor II

You are very welcome. Please mark this thread as answered.

Have a good day!

-Sam

0 Kudos