Note
This view is available starting with V4.3.2.
Purpose
The DBA_OB_SPATIAL_COLUMNS view displays the database name, table name, type, and SRS information of spatial index columns.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| TABLE_SCHEMA | VARCHAR2(128) | NO | The database to which the column belongs. |
| TABLE_NAME | VARCHAR2(256) | NO | The name of the table that contains the spatial column. |
| COLUMN_NAME | VARCHAR2(128) | NO | The name of the column. |
| SRS_NAME | VARCHAR2(128) | NO | The name of the spatial coordinate system. |
| SRS_ID | NUMBER(10) | NO | The ID of the spatial coordinate system. |
| GEOMETRY_TYPE_NAME | VARCHAR2(128) | NO | The type of spatial data. |
| DIMINFO | VARCHAR2(512) | NO | The settings for each dimension. This column is not supported. The default value is displayed. |
| INDEX_NAME | VARCHAR2(128) | NO | The name of the index corresponding to the column. If no index exists, this column is NULL. |
Sample query
Query the database name, table name, type, and SRS information of spatial index columns.
obclient [SYS]> SELECT * FROM SYS.DBA_OB_SPATIAL_COLUMNS;
The query result is as follows:
+--------------+-----------------+-------------+----------+--------+--------------------+-------------------------------------------------------------------------------------------+----------------------+
| TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | SRS_NAME | SRS_ID | GEOMETRY_TYPE_NAME | DIMINFO | INDEX_NAME |
+--------------+-----------------+-------------+----------+--------+--------------------+-------------------------------------------------------------------------------------------+----------------------+
| TEST | COLA_MARKETS_CS | SHAPE | NULL | 8307 | SDO_GEOMETRY | SDO_DIM_ARRAY(SDO_DIM_ELEMENT(NULL, -180, 180, 0.5), SDO_DIM_ELEMENT(NULL, -90, 90, 0.5)) | COLA_SPATIAL_IDX_CS |
| TEST | COLA_MARKETS_CS | SHAPE1 | WGS 84 | 4326 | SDO_GEOMETRY | SDO_DIM_ARRAY(SDO_DIM_ELEMENT(NULL, -180, 180, 0.5), SDO_DIM_ELEMENT(NULL, -90, 90, 0.5)) | NULL |
| TEST | COLA_MARKETS_CS | SHAPE2 | WGS 84 | 4326 | SDO_GEOMETRY | SDO_DIM_ARRAY(SDO_DIM_ELEMENT(NULL, -180, 180, 0.5), SDO_DIM_ELEMENT(NULL, -90, 90, 0.5)) | COLA_SPATIAL_IDX_CS2 |
+--------------+-----------------+-------------+----------+--------+--------------------+-------------------------------------------------------------------------------------------+----------------------+