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
Solved! Go to Solution.
Can you provide more information about the polygon feature class? What is the geometry storage type of the feature class?
Can you right click on the database connection and create a new view?
Hell Samuel. Thank you for your help. Yes, I am able to right click on the database connection in ArcCatalog and create a view. However, when I look at the created view in ArcCatalog it appers as a simple data table, not a polygon feature. When I look at the field type of the polygon feature in ArcCatalog I see that it is of type "Geometry". But if I look at the table in Oracle SQL Developer, the SHAPE column is of data type NUMBER.
Thank you again. David
Please go to the properties of the feature class in ArcCatalog, particularly the General tab.
You will see a section called Geometry Properties. What does the Storage part say?
The reason I ask is because views created with feature classes in Binary storage, will display strange behavior. We want to make sure the geometry storage for the feature class is either ST_Geometry or SDO_Geometry for Oracle when creating views in ArcCatalog or ArcMap.
Hello Samuel. I just went to ArcCatalog and checked the general tab of the properies on the feature class. Under Geometry Properties, it states "Storage: High Precision usning Esri Binary spatial type. Is that the problem? Thank you again for all of your help. David
We're running Oracle 11g. Okay, I found this:
I will follow the steps and see if this fixes the problem. I will let you know if it works. Thank you again.
Also, make sure you have a backup of the database or feature class. Once you move to ST_Geometry, you cannot use the migrate storage to migrate back to Binary.