Oracle8 Spatial Cartridge User's Guide and Reference
Release 8.0.4

A53264-02

Library

Product

Contents

Index

Prev Next

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

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
Oracle
Copyright © 1997 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index