Note
This view was introduced in OceanBase Database V4.3.2.
Purpose
The DBA_OB_SPATIAL_COLUMNS view displays the database names, table names, data types, and spatial reference system (SRS) information corresponding to spatial index columns.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TABLE_SCHEMA | VARCHAR2(128) | NO | The name of 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 spatial data type. |
| DIMINFO | VARCHAR2(512) | NO | The settings per dimension. At present, the default value of this column is displayed and the column value cannot be modified. |
| INDEX_NAME | VARCHAR2(128) | NO | The index name corresponding to the column. The value is NULL if the column has no index. |
Sample query
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 |
+--------------+-----------------+-------------+----------+--------+--------------------+-------------------------------------------------------------------------------------------+----------------------+