23.1 SDO_CSW.CREATE_SPATIAL_IDX
Format
SDO_CSW.CREATE_SPATIAL_IDX( owner IN VARCHAR2, csw_table_name IN VARCHAR2, srid IN NUMBER);
Description
Creates a spatial index on the CSW table, if no spatial index already exists.
Parameters
- owner
-
Name of the CSW schema for the table and spatial index.
- csw_table_name
-
Name of the table that holds the CSW catalog data.
- srid
-
The coordinate system (or SRID: spatial reference system) associated with the CSW catalog data. It should be the SRID in the geometry column of the CSW table. Example:
4326
(EPSG SRID value equivalent to Oracle SRID 8307).You can specify a 2D or 3D SRID value, but the geometry column of the CSW table must have the appropriate number of dimensions for the specified SRID.
Usage Notes
If a spatial index already exists on csw_table_name
, this procedure does nothing. If the spatial index already exists but needs to be re-created for CSW, you must drop the index, then create the index using this procedure. The USER_SDO_GEOM_METADATA view will be populated with the CSW table information.
This procedure uses the SDO_GEOMETRY objects from the XMLType column of the CSW table. These geometries are transformed into the coordinate reference system represented by the SRID parameter.
The created spatial index will have a name in the form csw_table_name_IDX
.
For information about support for Catalog Services for the Web, see Catalog Services for the Web (CSW) Support.
Examples
The following example creates a spatial index on the SCOTT.MY_CSW_CATALOG TABLE table, and it associates SRID 4326 with the spatial data.
DECLARE BEGIN sdo_csw.create_spatial_idx('SCOTT', 'MY_CSW_CATALOG_TABLE', 4326); END; /
Parent topic: SDO_CSW Package (Catalog Services for the Web)