New answers tagged oracle
You mean you have a table that contains a mix of polygons (SDO_GTYPE 2003) and multi-polygons (SDO_GTYPE 2007) and your application cannot handle that mix, i.e. it requires the input to be all SDO_GTYPE 2007 ? Like Vince said, you need to fix your application. I see no reason for such a requirement. Otherwise, you can actually force the SDO_TYPE of the ...
Your only solution is to fix the application, unless corrupting the single-part geometries by adding tiny holes with tinier islands or adding an out-of-bounds part to all geometries holds allure.
Go to ArcCatalog -> Database Connections -> Add Database Connections -> Database Platform: Oracle. This is setting up in arcmap:
Keep in mind what you are doing -- You are asking the database to return all features within the display envelope AND whose ids are in the first 1000. And you are likely doing so with a spatial constraint first option. Yes, it is very normal to see poor performance under such circumstances. Best practice for rendering very large tables is not to. This ...
More an additional Comment (with an image) than Answer Same Oracle Spatial Connection - Same TABLE - but using two TESTERs to define FeatureType and then write the to visualiser (or Shapefiles)
Top 50 recent answers are included