Oracle8 Spatial Cartridge User's Guide and Reference Release 8.0.4 A53264-02 |
Library | Product | Contents | Index

# B
Data Dictionary

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.

Note: Only the partitioned point routines use the Spatial Cartridge data dictionary.

The following views are publicly available:

- ALL_MD_COLUMNS
- ALL_MD_DIMENSIONS
- ALL_MD_EXCEPTIONS
- ALL_MD_LOADER_ERRORS
- ALL_MD_PARTITIONS
- ALL_MD_TABLES
- ALL_MD_TABLESPACES
- DBA_MD_COLUMNS
- DBA_MD_DIMENSIONS
- DBA_MD_EXCEPTIONS
- DBA_MD_LOADER_ERRORS
- DBA_MD_PARTITIONS
- DBA_MD_TABLES
- DBA_MD_TABLESPACES
- USER_MD_COLUMNS
- USER_MD_DIMENSIONS
- USER_MD_EXCEPTIONS
- USER_MD_LOADER_ERRORS
- USER_MD_PARTITIONS
- USER_MD_TABLES
- USER_MD_TABLESPACES

  warning: Do not delete or modify any of the tables in the mdsys account. This corrupts the Spatial Cartridge data dictionary.

##### ALL_MD_COLUMNS

Returns a list of all columns that are part of spatial tables.

Column | Description
--- | ---
OWNER | owner of the object
MD_TABLE_NAME | name of the spatial table
COLUMN_NAME | name of the column
DATA_TYPE | data type of the column
DATA_LENGTH | length of the column in bytes
DATA_PRECISION | scale for NUMBER data type, binary precision for FLOAT data type, and NULL for all other data types
DATA_SCALE | digits to right of decimal point in an HHCODE or a number
NDIM | number of dimensions in the HHCODE column (It is NULL for all other data types.)
MAX_LEVEL | maximum number of levels in the column
NULLABLE | indicates if column allows NULL values
PARTITION_KEY | indicates if column is the partition key column; only one is allowed per partitioned table
COLUMN_ID | sequence number of the column as created
DEFAULT_LENGTH | length of the default value for the column
NUM_DISTINCT | number of distinct values in each column of the table
LOW_VALUE | lowest value for tables with three or fewer rows (It is the second-lowest value in the column for tables with more than three rows.)
HIGH_VALUE | highest value for tables with three or fewer rows (It is the second-highest value in the column for tables with more than three rows.)

##### ALL_MD_DIMENSIONS

Returns a list of all dimensions that are part of HHCODE columns.

Column | Description
--- | ---
OWNER | owner of the object
MD_TABLE_NAME | name of the spatial table
COLUMN_NAME | name of the column
DIMENSION_NAME | name of the dimension
DIMENSION_NUMBER | dimension number
LOWER_BOUND | lower boundary of the dimension range
UPPER_BOUND | upper boundary of the dimension range
SCALE | scale of the dimension
RECURSION_LEVEL | number of levels encoded in the HHCODE

##### ALL_MD_EXCEPTIONS

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

##### ALL_MD_LOADER_ERRORS

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

##### ALL_MD_PARTITIONS

Returns a list of all the partitioned tables that are part of a user-accessible spatial table.

Column | Description
--- | ---
OWNER | owner of the object
MD_TABLE_NAME | name of the spatial table
PARTITION_TABLE_NAME | name of the partitioned table
CLASS | class of partition: NODE or LEAF
COMMON_LEVEL | number of levels of resolution of the common HHCODE for the partition
COMMON_HHCODE | common HHCODE substring for the partition
OFFLINE_STATUS | status of partition: ONLINE or OFFLINE
ARCHIVE_DATE | date of last archive

##### ALL_MD_TABLES

Returns a list of all the user-accessible spatial tables.

Column | Description
--- | ---
OWNER | owner of the table
MD_TABLE_NAME | name of the spatial table
CLASS | class of table: PARTITIONED or NON-PARTITIONED
PTAB_SEQ | number of last partitioned table created
HIGH_WATER_MARK | maximum number of rows that can be inserted into a partitioned table
OFFLINE_PATH | complete path name to directory where the table is archived
COUNT_MODE | count mode for estimating number of rows in a partition: ESTIMATE or EXACT

##### ALL_MD_TABLESPACES

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

##### DBA_MD_COLUMNS

Returns a list of all columns that are part of Spatial Cartridge tables.

Column | Description
--- | ---
OWNER | owner of the object
MD_TABLE_NAME | name of the spatial table
COLUMN_NAME | name of the column
DATA_TYPE | data type of the column
DATA_LENGTH | length of the column in bytes
DATA_PRECISION | scale for NUMBER data type, binary precision for FLOAT data type, and NULL for all other data types
DATA_SCALE | digits to right of decimal point in an HHCODE or a number
NDIM | number of dimensions in the HHCODE column (It is NULL for all other data types.)
MAX_LEVEL | maximum number of levels in the column
NULLABLE | indicates if column allows NULL values
PARTITION_KEY | indicates if column is the partition key column; only one is allowed per partitioned table
COLUMN_ID | sequence number of the column as created
DEFAULT_LENGTH | length of the default value for the column
NUM_DISTINCT | number of distinct values in each column of the table
LOW_VALUE | lowest value for tables with three or fewer rows (It is the second-lowest value in the column for tables with more than three rows.)
HIGH_VALUE | highest value for tables with three or fewer rows (It is the second-highest value in the column for tables with more than three rows.)

##### DBA_MD_DIMENSIONS

Returns a list of all dimensions that are a part of spatial tables.

Column | Description
--- | ---
OWNER | owner of the object
MD_TABLE_NAME | name of the spatial table
COLUMN_NAME | name of the column
DIMENSION_NAME | name of the dimension
DIMENSION_NUMBER | dimension number
LOWER_BOUND | lower boundary of the dimension range
UPPER_BOUND | upper boundary of the dimension range
SCALE | scale of the dimension
RECURSION_LEVEL | number of levels encoded in the HHCODE

##### DBA_MD_EXCEPTIONS

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

##### DBA_MD_LOADER_ERRORS

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

##### DBA_MD_PARTITIONS

Returns a list of all the partitioned tables.

Column | Description
--- | ---
OWNER | owner of the object
MD_TABLE_NAME | name of the spatial table
PARTITION_TABLE_NAME | name of the partitioned table
CLASS | class of partition: NODE or LEAF
COMMON_LEVEL | number of levels of resolution of the common HHCODE for the partition
COMMON_HHCODE | common HHCODE substring for the partition
OFFLINE_STATUS | status of partition: ONLINE or OFFLINE
ARCHIVE_DATE | date of last archive

##### DBA_MD_TABLES

Returns a list of all the spatial tables.

Column | Description
--- | ---
OWNER | owner of the table
MD_TABLE_NAME | name of the spatial table
CLASS | class of table: PARTITIONED or NON-PARTITIONED
PTAB_SEQ | number of last partitioned table created
HIGH_WATER_MARK | maximum number of rows that can be inserted into a partitioned table
OFFLINE_PATH | complete path name to directory where the table is archived
COUNT_MODE | count mode for estimating number of rows in a partition: ESTIMATE or EXACT

##### DBA_MD_TABLESPACES

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

##### USER_MD_COLUMNS

Returns a list of all the HHCODE columns that are part of tables owned by the user.

Column | Description
--- | ---
MD_TABLE_NAME | name of the spatial table
COLUMN_NAME | name of the spatial table
DATA_TYPE | data type of the column
DATA_LENGTH | length of the column in bytes
DATA_PRECISION | scale for NUMBER data type, binary precision for FLOAT data type, and NULL for all other data types
DATA_SCALE | digits to right of the decimal point in an HHCODE or a number
NDIM | number of dimensions in the HHCODE column (It is NULL for all other data types.)
MAX_LEVEL | maximum number of levels in the column
NULLABLE | indicates if column allows NULL values
PARTITION_KEY | indicates if column is the partition key column; only one allowed per partitioned table
COLUMN_ID | sequence number of the column as created
DEFAULT_LENGTH | length of the default value for the column
NUM_DISTINCT | number of distinct values in each column of the table
LOW_VALUE | lowest value for tables with three or fewer rows (It is the second-lowest value in the column for tables with more than three rows.)
HIGH_VALUE | highest value for tables with three or fewer rows (It is the second-highest value in the column for tables with more than three rows.)

##### USER_MD_DIMENSIONS

Returns a list of all dimensions that are part of HHCODE columns owned by the user.

Column | Description
--- | ---
MD_TABLE_NAME | name of the spatial table
COLUMN_NAME | name of the column
DIMENSION_NAME | name of the dimension
DIMENSION_NUMBER | dimension number
LOWER_BOUND | lower boundary of dimension range
UPPER_BOUND | upper boundary of dimension range
SCALE | scale of the dimension
RECURSION_LEVEL | number of levels encoded in the HHCODE

##### USER_MD_EXCEPTIONS

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

##### USER_MD_LOADER_ERRORS

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

##### USER_MD_PARTITIONS

Returns a list of all the partitioned tables that are part of spatial tables owned by the user.

Column | Description
--- | ---
MD_TABLE_NAME | name of the spatial table
PARTITION_TABLE_NAME | name of the partition
CLASS | class of partition: NODE or LEAF
COMMON_LEVEL | number of levels of resolution of the common HHCODE for the partition
COMMON_HHCODE | common HHCODE substring for the partition
OFFLINE_STATUS | status of partition: ONLINE or OFFLINE
ARCHIVE_DATE | date of last archive

##### USER_MD_TABLES

Returns a list of all the spatial tables owned by the user.

Column | Description
--- | ---
MD_TABLE_NAME | name of the spatial table
CLASS | class of table: PARTITIONED or NON-PARTITIONED
PTAB_SEQ | number of last sequence created
HIGH_WATER_MARK | maximum number of rows that can be inserted into a partitioned table
OFFLINE_PATH | complete path name to directory where the table is archived
COUNT_MODE | count mode for estimating number of rows in a partition: ESTIMATE or EXACT

##### USER_MD_TABLESPACES

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

Prev | Next
| Copyright © 1997 Oracle Corporation. All Rights Reserved. |
Library | Product | Contents | Index