views with SDO_GEOMETRY
For spatial data tables are quite common views generated. Data from different tables are therefore almost as "a table ready. And you may agree with the views that work very well. Just let the views of many GIS tools and the Oracle MapBuilder (the tool for setting up the map definitions for Oracle MAPS) do not use - the choice of dialogue they simply do not show. Friday, November 12, 2010
Military Emergency Leave
is now on the view not a spatial index, but this is rightly so, to a view index can not be set. The reason is the Spatial Metadata View that is read by all these tools and usually based on the selection lists.
The solution is simple: The View, as the underlying spatial table published in USER_SDO_GEOM_METADATA . Take this simple SQL here as a template.
USER_SDO_GEOM_METADATA insert into values ('{TABLE / VIEW NAME}', '{} GEOM_COL_NAME' sdo_dim_array (sdo_dim_element ('X', {xmin} {xmax}, {tolerance}), sdo_dim_element ('Y', { can ymin}, {ymax}, {tolerance})) {} SRID) / An index your still does not create - But you need not - the view should now be in your GIS tool or Oracle MapBuilder visible and selectable.
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment