crystalcarreon

Oracle Query Layer not Displaying

Discussion created by crystalcarreon on May 9, 2013
Latest reply on Mar 18, 2014 by vangelo-esristaff
I am having an issue with an Oracle query layer using SDO_Geometry not displaying. I have created a polygon layer/table within oracle, registered the table with the SDO_GEOM_METADATA and created a spatial index...twice. Unfortunately, I am still unable to see the polygons display in an ArcMap query layer. I am able to bring the data into arcmap, open the table, select and identify it and actually see the shape flash, so I know it is there. Also, I can export a shapefile and the shapes render perfectly fine, but for some reason they will not display from the query layer directly. I have checked over the index parameters in the registry and nothing seems off, see: INSERT INTO all_sdo_geom_metadata (owner, table_name, column_name, diminfo, srid) VALUES ('DB', 'TABLE', 'GEOM', MDSYS.sdo_dim_array (MDSYS.sdo_dim_element ('X', -180,180,5.0e-10), MDSYS.sdo_dim_element ('Y',-90,90,5.0e-10)),4326); index creation: CREATE INDEX wm_dim_table_si ON TABLE (geom) INDEXTYPE IS MDSYS.spatial_index PARAMETERS ('tablespace=DB_INDEX03 layer_gtype=MULTIPOLYGON');

I've done everything, others have prescribed but I still can't view the data directly...Any hints as to what else I should try or should be looking at? Any help is greatly appreciated. My nexts thoughts are that I should check and validate the geometry on the polygons. Also, there are about 30,000 polygons in this table, is there a threshold in armap for query layers? It wouldn't seem so, however I am at a loss right now...

Outcomes