Oracle8 Spatial Cartridge User's Guide and Reference Release 8.0.4 A53264-02 |
|
The Spatial Cartridge data dictionary is a set of tables owned by the database user mdsys. An extension to the Oracle8 data dictionary, it automatically maintains information about spatial tables, columns, and partitions. The Spatial Cartridge data dictionary is created during the installation process. All nonspatial attribute information is maintained in the Oracle8 data dictionary.
The Spatial Cartridge data dictionary has public views that provide extensive information about spatial tables. This appendix contains descriptions of the views that are available.
The following views are publicly available:
Returns a list of all columns that are part of spatial tables.
Returns a list of all dimensions that are part of HHCODE columns.
Contains information about spatial tables that should be dropped as a result of some failed operation, such as a failed load.
Column | Description |
---|---|
OWNER |
owner of the object |
NAME |
object name |
OPERATION |
operation during which the failure occurred |
CCHH |
common code HHCODE |
Contains the current status of a file that was loaded into a table using SD*Loader.
Column | Description |
---|---|
OWNER |
owner of the object |
MD_TABLE_NAME |
spatial table name |
FILENAME |
SLF file name |
ROWS_LOADED |
number of rows loaded before failure |
Returns a list of all the partitioned tables that are part of a user-accessible spatial table.
Returns a list of all the user-accessible spatial tables.
Returns a list of all tablespaces used by spatial tables.
Column | Description |
---|---|
OWNER |
owner of the object |
MD_TABLE_NAME |
name of the spatial table |
TABLESPACE_NAME |
name of tablespace |
SEQUENCE |
sequence number |
STATUS |
status of tablespace: ACTIVE or INACTIVE |
Returns a list of all columns that are part of Spatial Cartridge tables.
Returns a list of all dimensions that are a part of spatial tables.
Contains information about spatial tables that should be dropped as a result of some failed operation, such as a failed load.
Column | Description |
---|---|
OWNER |
owner of the object |
NAME |
object name |
OPERATION |
operation during which the failure occurred |
CCHH |
common code HHCODE |
Contains the current status of a file that was loaded into a table using SD*Loader.
Column | Description |
---|---|
OWNER |
owner of the table where the error occurred |
MD_TABLE_NAME |
spatial table name |
FILENAME |
SLF file name |
ROWS_LOADED |
number of rows loaded before failure |
Returns a list of all the partitioned tables.
Returns a list of all the spatial tables.
Returns a list of all tablespaces used by spatial tables.
Column | Description |
---|---|
OWNER |
owner of the object |
MD_TABLE_NAME |
name of the spatial table |
TABLESPACE_NAME |
name of tablespace |
SEQUENCE |
sequence number |
STATUS |
status of tablespace: ACTIVE or INACTIVE |
Returns a list of all the HHCODE columns that are part of tables owned by the user.
Returns a list of all dimensions that are part of HHCODE columns owned by the user.
Contains information about spatial tables that should be dropped as a result of some failed operation, such as a failed load.
Column | Description |
---|---|
NAME |
object name |
OPERATION |
operation during which the failure occurred |
CCHH |
common code HHCODE |
Contains the current status of a file that was loaded into a table using SD*Loader.
Column | Description |
---|---|
MD_TABLE_NAME |
spatial table name |
FILENAME |
SLF file name |
ROWS_LOADED |
number of rows loaded before failure |
Returns a list of all the partitioned tables that are part of spatial tables owned by the user.
Returns a list of all the spatial tables owned by the user.
Returns a list of all tablespaces used by spatial tables.
Column | Description |
---|---|
MD_TABLE_NAME |
name of the spatial table |
TABLESPACE_NAME |
name of tablespace |
SEQUENCE |
sequence number |
STATUS |
status of the tablespace: ACTIVE or INACTIVE |