Oracle7 Spatial Data Option User's Guide and Reference

Library

Product

Contents

Index

Data Dictionary

The Spatial Data Option data dictionary is a set of tables owned by the database user MDSYS. An extension to the Oracle7 data dictionary, it automatically maintains information about spatial tables, columns, and partitions. The Spatial Data Option data dictionary is created during the installation process. All non-spatial attribute information is maintained in the Oracle7 data dictionary.

The Spatial Data Option 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:

• 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_DIMENSION

• 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 Data Option data dictionary.

  ALL_MD_DIMENSIONS

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 fail 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_PARTITION

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 partitio
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 pathname 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 Data Option tables.

Column	Description
OWNER	owner of the object
MD_TABLE_NAME	name of the spatial table
COLUMN_NAME	name of the column
DATA_TYPE	datatype of the column
DATA_LENGTH	length of the column in bytes
DATA_PRECISION	scale for NUMBER datatype, binary precision for FLOAT datatype, and NULL for all other datatypes
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 datatypes
MAX_LEVEL	maximum number of levels in the column
NULLABLE	indicates if column allows NULLs
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 fail 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 tabl
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 pathname 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

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	datatype of the column
DATA_LENGTH	length of the column in bytes
DATA_PRECISION	scale for NUMBER datatype, binary precision for FLOAT datatype, and NULL for all other datatypes
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 datatypes
MAX_LEVEL	maximum number of levels in the column
NULLABLE	indicates if column allows NULLs
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 sec ond-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 sec ond-highest value in the column for tables with more than three rows

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	datatype of the column
DATA_LENGTH	length of the column in bytes
DATA_PRECISION	scale for NUMBER datatype, binary precision for FLOAT datatype, and NULL for all other datatypes
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 datatypes
MAX_LEVEL	maximum number of levels in the column
NULLABLE	indicates if column allows NULLs
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 dimensio
RECURSION_LEVE	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 fail 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 pathname 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 © 1996 Oracle Corporation. All Rights Reserved.

Library

Product

Contents

Index