C Data Dictionary

The Oracle Database Gateway for IMS translates a query that refers to an Oracle database server data dictionary table into a query that retrieves the data from an IMS data dictionary. You perform queries on data dictionary tables over the database link in the same way you query data dictionary tables in the Oracle database server. The gateway data dictionary is similar to the Oracle database server data dictionary in appearance and use.

This appendix contains the following sections:

Data Dictionary Support
IMS Data Dictionary Descriptions

C.1 Data Dictionary Support

Data dictionary information is stored in the gateway's advanced data dictionary (ADD). The views and tables that the gateway supports provide information on the following:

The tables existing in the data source
The columns for each table
The primary key for each table
The foreign keys for each table
Which primary key each foreign key references
The existing users and indexes

The following paragraphs describe the Oracle Database Gateway for IMS data dictionary support.

C.1.1 Accessing the Gateway Data Dictionary

Accessing an ADD record definition is identical to accessing a data dictionary table or view definition on an Oracle database. You issue a SQL SELECT statement specifying a database link. The Oracle database server data dictionary view and column names are used to access the gateway data dictionary. Synonyms of supported views are also acceptable. For example, the following statement queries the data dictionary table ALL_TABLES:

SQL> SELECT * FROM ALL_TABLES@IMS;

When a data dictionary access query is issued, the gateway performs the following operations:

Maps the requested table, view, or synonym to one or more ADD names.
Processes the query within the gateway.
May convert the retrieved data to give it the appearance of the Oracle database server data dictionary table.
Passes the data dictionary information to the Oracle database server.

C.1.2 Supported Views and Tables

The gateway supports the following views and tables:

Supported Views and Tables
ALL_CATALOG
ALL_CONS_COLUMNS
ALL_IND_COLUMNS
ALL_OBJECTS
ALL_TAB_COMMENTS
ALL_USERS
DBA_CATALOG
DBA_OBJECTS
DICTIONARY
USER_CATALOG
USER_CONS_COLUMNS
USER_IND_COLUMNS
USER_TAB_COMMENTS
USER_OBJECTS
USER_USERS
ALL_COL_COMMENTS
ALL_CONSTRAINTS
ALL_INDEXES
ALL_TAB_COLUMNS
ALL_TABLES
ALL_VIEWS
DBA_TAB_COLUMNS
DICT_COLUMNS
DUAL
USER_COL_COMMENTS
USER_CONSTRAINTS
USER_INDEXES
USER_TAB_COLUMNS
USER_TABLES
USER_VIEWS

No other Oracle database server data dictionary tables or views are supported. If you use a view not on the list, you receive the Oracle database server error code for no more rows available.

To select data dictionary views using SELECT FROM DBA_*, first connect as Oracle user SYSTEM or SYS. Otherwise, you receive the following error message:

ORA-28506: Parse error in data dictionary translation for %s stored in %s

Queries through the gateway of any data dictionary table or view beginning with ALL_ can returns rows from IMS even when access privileges for those IMS objects have not been granted. When querying an Oracle database with the Oracle data dictionary, rows are returned only for those objects you are permitted to access.

C.1.3 Default Column Values

There is a minor difference between the gateway data dictionary and a typical Oracle database server data dictionary. The Oracle database server columns that are missing in an IMS data dictionary table are filled with zeros, spaces, null values, or default values, depending on the column type.

C.2 IMS Data Dictionary Descriptions

The gateway data dictionary tables and views provide the following information:

Name, datatype, and width of each column.
The contents of columns with fixed values.

In the descriptions that follow, the values in the Null? column may differ from the Oracle database server data dictionary tables and views. Any default value is shown to the right of an item.

Note:

In all data dictionary tables, the OWNER column has the value IMS.

Table C-1 describes the ALL_CATALOG table.

Table C-1 ALL_CATALOG

Name	Null?	Type	Value
`OWNER`	`NOT` `NULL`	`VARCHAR2(30)`	`IMS`
`TABLE_NAME`	`NOT` `NULL`	`VARCHAR2(30)`	-
`TABLE_TYPE`	-	`VARCHAR2(11)`	"`TABLE`"

Table C-2 describes the ALL_COL_COMMENTS table.

Table C-2 ALL_COL_COMMENTS

Name	Null?	Type	Value
`OWNER`	`NOT` `NULL`	`VARCHAR2(30)`	`IMS`
`TABLE_NAME`	`NOT` `NULL`	`VARCHAR2(30)`	-
`COLUMN_NAME`	`NOT` `NULL`	`VARCHAR2`(30)	-
`COMMENTS`	`NOT` `NULL`	`CHAR(1)`	-

Table C-3 describes the ALL_CONS_COLUMNS table.

Table C-3 ALL_CONS_COLUMNS

Name	Null?	Type	Value
`OWNER`	`NOT NULL`	`VARCHAR2(30)`	-
`CONSTRAINT_NAME`	`NOT NULL`	`VARCHAR2(30)`	-
`TABLE_NAME`	`NOT NULL`	`VARCHAR2(30)`	-
`COLUMN_NAME`	-	`VARCHAR2(4000)`	-
`POSITION`	-	`FLOAT(49)`	-

Table C-4 describes the ALL_CONSTRAINTS table.

Table C-4 ALL_CONSTRAINTS

Name	Null?	Type	Value
`OWNER`	`NOT NULL`	`VARCHAR(3)`	`IMS`
`CONSTRAINT_NAME`	`NOT NULL`	`VARCHAR2(30)`	-
`CONSTRAINT_TYPE`	-	`VARCHAR2(1)`	"`R`" or "`P`"
`TABLE_NAME`	`NOT NULL`	`VARCHAR2(30)`	-
`SEARCH_CONDITION`	`NOT NULL`	`CHAR(1)`	-
`R_OWNER`	-	`VARCHAR(3)`	-
`R_CONSTRAINT_NAME`	-	`VARCHAR2(30)`	-
`DELETE_RULE`	`NOT NULL`	`VARCHAR(7)`	-
`STATUS`	`NOT NULL`	`CHAR(1)`	-
`DEFERRABLE`	`NOT NULL`	`CHAR(1)`	-
`DEFERRED`	`NOT NULL`	`CHAR(1)`	-
`VALIDATED`	`NOT NULL`	`CHAR(1)`	-
`GENERATED`	`NOT NULL`	`CHAR(1)`	-
`BAD`	`NOT NULL`	`CHAR(1)`	-
`RELY`	`NOT NULL`	`CHAR(1)`	-
`LAST_CHANGE`	-	`DATE`	`NULL`

Table C-5 describes the ALL_IND_COLUMNS table.

Table C-5 ALL_IND_COLUMNS

Name	Null?	Type	Value
`INDEX_OWNER`	`NOT` `NULL`	`VARCHAR2(30)`	-
`INDEX_NAME`	`NOT` `NULL`	`VARCHAR2(30)`	-
`TABLE_OWNER`	`NOT` `NULL`	`VARCHAR2(30)`	-
`TABLE_NAME`	`NOT` `NULL`	`VARCHAR2(30)`	-
`COLUMN_NAME`	-	`VARCHAR2(4000)`	-
`COLUMN_POSITION`	`NOT NULL`	`FLOAT(49)`	-
`COLUMN_LENGTH`	`NOT` `NULL`	`FLOAT(49)`	-
`DESCEND`	-	`VARCHAR2(4)`	`NULL`

Table C-6 describes the ALL_INDEXES table.

Table C-6 ALL_INDEXES

Name	Null?	Type	Value
`OWNER`	`NOT` `NULL`	`VARCHAR2(30)`	`IMS`
`INDEX_NAME`	`NOT` `NULL`	`VARCHAR2(30)`	-
`INDEX_TYPE`	`NOT` `NULL`	`CHAR(1)`	-
`TABLE_OWNER`	`NOT` `NULL`	`VARCHAR2(30)`	-
`TABLE_NAME`	`NOT NULL`	`VARCHAR2(30)`	-
`TABLE_TYPE`	`NOT` `NULL`	`CHAR(5)`	"`TABLE`"
`UNIQUENESS`	-	`VARCHAR2(9)`	"`UNIQUE`" or "`NONUNIQUE`"
`COMPRESSION`	`NOT` `NULL`	`CHAR(1)`	-
`PREFIX_LENGTH`	`NOT` `NULL`	`NUMBER(10)`	0
`TABLESPACE_NAME`	`NOT` `NULL`	`CHAR(1)`	-
`INI_TRANS`	`NOT` `NULL`	`NUMBER(10)`	0
`MAX_TRANS`	`NOT` `NULL`	`NUMBER(10)`	0
`INITIAL_EXTENT`	`NOT` `NULL`	`NUMBER(10)`	0
`NEXT_EXTENT`	`NOT` `NULL`	`NUMBER(10)`	0
`MIN_EXTENTS`	`NOT` `NULL`	`NUMBER(10)`	0
`MAX_EXTENTS`	`NOT` `NULL`	`NUMBER(10)`	0
`PCT_INCREASE`	`NOT` `NULL`	`NUMBER(10)`	0
`PCT_THRESHOLD`	`NOT` `NULL`	`NUMBER(10)`	0
`INCLUDE_COLUMN`	`NOT` `NULL`	`NUMBER(10)`	0
`FREELISTS`	`NOT` `NULL`	`NUMBER(10)`	0
`FREELIST_GROUPS`	`NOT` `NULL`	`NUMBER(10)`	0
`PCT_FREE`	`NOT` `NULL`	`NUMBER(10)`	`0`
`LOGGING`	`NOT` `NULL`	`CHAR(1)`	-
`BLEVEL`	`NOT` `NULL`	`NUMBER(10)`	`0`
`LEAF_BLOCKS`	`NOT` `NULL`	`NUMBER(10)`	`0`
`DISTINCT_KEYS`	-	`FLOAT(49)`	-
`AVG_LEAF_BLOCKS_PER_KEY`	`NOT` `NULL`	`NUMBER(10)`	`0`
`AVG_DATA_BLOCKS_PER_KEY`	`NOT` `NULL`	`NUMBER(10)`	`0`
`CLUSTERING_FACTOR`	`NOT` `NULL`	`NUMBER(10)`	`0`
`STATUS`	`NOT` `NULL`	`CHAR(1)`	`NULL`
`NUM_ROWS`	`NOT` `NULL`	`NUMBER(10)`	`0`
`SAMPLE_SIZE`	`NOT` `NULL`	`NUMBER(10)`	`0`
`LAST_ANALYZED`	-	`DATE`	`NULL`
`DEGREE`	`NOT` `NULL`	`CHAR(1)`	`NULL`
`INSTANCES`	`NOT` `NULL`	`CHAR(1)`	`NULL`
`PARTITIONED`	`NOT` `NULL`	`CHAR(1)`	`NULL`
`TEMPORARY`	`NOT` `NULL`	`CHAR(1)`	-
`GENERATED`	`NOT` `NULL`	`CHAR(1)`	-
`SECONDARY`	`NOT` `NULL`	`CHAR(1)`	-
`BUFFER_POOL`	`NOT` `NULL`	`CHAR(1)`	-
`USER_STATS`	`NOT` `NULL`	`CHAR(1)`	-
`DURATION`	`NOT` `NULL`	`CHAR(1)`	-
`PCT_DIRECT_ACCESS`	`NOT` `NULL`	`NUMBER(10)`	`0`
`ITYP_OWNER`	`NOT` `NULL`	`CHAR(1)`	-
`ITYP_NAME`	`NOT` `NULL`	`CHAR(1)`	-
`PARAMETERS`	`NOT` `NULL`	`CHAR(1)`	-
`GLOBAL_STATS`	`NOT` `NULL`	`CHAR(1)`	-
`DOMIDX_STATUS`	`NOT` `NULL`	`CHAR(1)`	-
`DOMIDX_OPSTATUS`	`NOT` `NULL`	`CHAR(1)`	-
`FUNCIDX_STATUS`	`NOT` `NULL`	`CHAR(1)`	-

Table C-7 describes the ALL_OBJECTS table.

Table C-7 ALL_OBJECTS

Name	Null?	Type	Value
`OWNER`	-	`VARCHAR2(30)`	`IMS`
`OBJECT_NAME`	-	`VARCHAR2(30)`	-
`SUBOBJECT_NAME`	-	`VARCHAR2(1)`	`NULL`
`OBJECT_ID`	-	`NUMBER`	`0`
`DATA_OBJECT_ID`	-	`NUMBER`	`0`
`OBJECT_TYPE`	-	`VARCHAR2(18)`	"`TABLE`" or "`INDEX`"
`CREATED`	-	`DATE`	`NULL`
`LAST_DDL_TIME`	-	`DATE`	`NULL`
`TIMESTAMP`	-	`VARCHAR2(1)`	`NULL`
`STATUS`	-	`VARCHAR2(1)`	`NULL`
`TEMPORARY`	-	`VARCHAR2(1)`	`NULL`
`GENERATED`	-	`VARCHAR2(1)`	`NULL`
`SECONDARY`	-	`VARCHAR2(1)`	`NULL`

Table C-8 describes the ALL_TAB_COLUMNS table.

Table C-8 ALL_TAB_COLUMNS

Name	Null?	Type	Value
`OWNER`	`NOT` `NULL`	`VARCHAR2(30)`	`IMS`
`TABLE_NAME`	`NOT` `NULL`	`VARCHAR2(30)`	-
`COLUMN_NAME`	`NOT` `NULL`	`VARCHAR2(30)`	-
`DATA_TYPE`	-	`VARCHAR2(106)`	-
`DATA_TYPE_MOD`	`NOT` `NULL`	`CHAR(1)`	-
`DATA_TYPE_OWNER`	`NOT` `NULL`	`CHAR(1)`	-
`DATA_LENGTH`	`NOT` `NULL`	`FLOAT(49)`	-
`DATA_PRECISION`	-	`FLOAT(49)`	-
`DATA_SCALE`	-	`FLOAT(49)`	-
`NULLABLE`	-	`VARCHAR2(1)`	"`Y`" or "`N`"
`COLUMN_ID`	`NOT` `NULL`	`FLOAT(49)`	-
`DEFAULT_LENGTH`	`NOT` `NULL`	`NUMBER(10)`	`0`
`DATA_DEFAULT`	`NOT` `NULL`	`CHAR(1)`	-
`NUM_DISTINCT`	`NOT` `NULL`	`NUMBER(10)`	`0`
`LOW_VALUE`	`NOT` `NULL`	`NUMBER(10)`	-
`HIGH_VALUE`	`NOT` `NULL`	`NUMBER(10)`	-
`DENSITY`	`NOT` `NULL`	`NUMBER(10)`	`0`
`NUM_NULLS`	`NOT` `NULL`	`NUMBER(10)`	`0`
`NUM_BUCKETS`	`NOT` `NULL`	`NUMBER(10)`	`0`
`LAST_ANALYZED`	-	`DATE`	`NULL`
`SAMPLE_SIZE`	`NOT` `NULL`	`NUMBER(10)`	`0`
`CHARACTER_SET_NAME`	`NOT` `NULL`	`CHAR(1)`	-
`CHAR_COL_DEC_LENGTH`	`NOT` `NULL`	`NUMBER(10)`	`0`
`GLOBAL_STATS`	`NOT` `NULL`	`CHAR(1)`	-
`USER_STATS`	`NOT` `NULL`	`CHAR(1)`	-
`AVG_COL_LEN`	`NOT NULL`	`NUMBER(10)`	0

Table C-9 describes the ALL_TAB_COMMENTS table.

Table C-9 ALL_TAB_COMMENTS

Name	Null?	Type	Value
`OWNER`	`NOT NULL`	`VARCHAR2(30)`	`IMS`
`TABLE_NAME`	`NOT NULL`	`VARCHAR2(30)`	-
`TABLE_TYPE`	-	`VARCHAR2(11)`	"`TABLE`"
`COMMENTS`	`NOT NULL`	`CHAR(1)`	-

Table C-10 describes the ALL_TABLES table.

Table C-10 ALL_TABLES

Name	Null?	Type	Value
`OWNER`	`NOT` `NULL`	`VARCHAR2(30)`	`IMS`
`TABLE_NAME`	`NOT` `NULL`	`VARCHAR2(30)`	-
`TABLESPACE_NAME`	`NOT` `NULL`	`CHAR(1)`	-
`CLUSTER_NAME`	`NOT` `NULL`	`CHAR(1)`	-
`IOT_NAME`	`NOT` `NULL`	`CHAR(1)`	-
`PCT_FREE`	`NOT` `NULL`	`NUMBER(10)`	0
`PCT_USED`	`NOT` `NULL`	`NUMBER(10)`	0
`INI_TRANS`	`NOT` `NULL`	`NUMBER(10)`	0
`MAX_TRANS`	`NOT` `NULL`	`NUMBER(10)`	0
`INITIAL_EXTENT`	`NOT` `NULL`	`NUMBER(10)`	0
`NEXT_EXTENT`	`NOT` `NULL`	`NUMBER(10)`	0
`MIN_EXTENTS`	`NOT` `NULL`	`NUMBER(10)`	0
`MAX_EXTENTS`	`NOT` `NULL`	`NUMBER(10)`	0
`PCT_INCREASE`	`NOT` `NULL`	`NUMBER(10)`	0
`FREELISTS`	`NOT` `NULL`	`NUMBER(10)`	0
`FREELIST_GROUPS`	`NOT` `NULL`	`NUMBER(10)`	0
`LOGGING`	`NOT` `NULL`	`CHAR(1)`	-
`BACKED_UP`	`NOT` `NULL`	`CHAR(1)`	-
`NUM_ROWS`	-	`FLOAT(49)`	-
`BLOCKS`	-	`FLOAT(49)`	-
`EMPTY_BLOCKS`	`NOT` `NULL`	`NUMBER(10)`	0
`AVG_SPACE`	`NOT` `NULL`	`NUMBER(10)`	0
`CHAIN_CNT`	`NOT` `NULL`	`NUMBER(10)`	0
`AVG_ROW_LEN`	`NOT` `NULL`	`NUMBER(10)`	0
`AVG_SPACE_FREELIST_BLOCKS`	`NOT` `NULL`	`NUMBER(10)`	0
`NUM_FREELIST_BLOCKS`	`NOT` `NULL`	`NUMBER(10)`	0
`DEGREE`	`NOT` `NULL`	`CHAR(1)`	-
`INSTANCES`	`NOT` `NULL`	`CHAR(1)`	-
`CACHE`	`NOT` `NULL`	`CHAR(1)`	-
`TABLE_LOCK`	`NOT` `NULL`	`CHAR(1)`	-
`SAMPLE_SIZE`	`NOT` `NULL`	`NUMBER (10)`	`0`
`LAST_ANALYZED`	-	`DATE`	`NULL`
`PARTITIONED`	`NOT` `NULL`	`CHAR(1)`	-
`IOT_TYPE`	`NOT` `NULL`	`CHAR(1)`	-
`TEMPORARY`	`NOT` `NULL`	`CHAR(1)`	-
`SECONDARY`	`NOT` `NULL`	`CHAR(1)`	-
`NESTED`	`NOT` `NULL`	`CHAR(1)`	-
`BUFFER_POOL`	`NOT` `NULL`	`CHAR(1)`	-
`ROW_MOVEMENT`	`NOT` `NULL`	`CHAR(1)`	-
`GLOBAL_STATS`	`NOT` `NULL`	`CHAR(1)`	-
`USER_STATS`	`NOT` `NULL`	`CHAR(1)`	-
`DURATION`	`NOT` `NULL`	`CHAR(1)`	-
`SKIP_CORRUPT`	`NOT` `NULL`	`CHAR(1)`	-
`MONITORING`	`NOT` `NULL`	`CHAR(1)`	-

Table C-11 describes the ALL_USERS table.

Table C-11 ALL_USERS

Name	Null?	Type	Value
`USERNAME`	`NOT NULL`	`VARCHAR2(30)`	-
`USER_ID`	-	`NUMBER`	`0`
`CREATED`	-	`DATE`	`NULL`

Table C-12 describes the ALL_VIEWS table.

Table C-12 ALL_VIEWS

Name	Null?	Type	Value
`OWNER`	`NOT` `NULL`	`VARCHAR2(30)`	`IMS`
`VIEW_NAME`	`NOT` `NULL`	`VARCHAR2(30)`	-
`TEXT_LENGTH`	`NOT` `NULL`	`NUMBER(10)`	`0`
`TEXT`	`NOT` `NULL`	`CHAR(1)`	-
`TYPE_TEXT_LENGTH`	`NOT` `NULL`	`NUMBER(10)`	`0`
`TYPE_TEXT`	`NOT` `NULL`	`CHAR(1)`	-
`OID_TEXT_LENGTH`	`NOT` `NULL`	`NUMBER(10)`	`0`
`OID_TEXT`	`NOT` `NULL`	`CHAR(1)`	-
`VIEW_TYPE_OWNER`	`NOT` `NULL`	`CHAR(1)`	-
`VIEW_TYPE`	`NOT` `NULL`	`CHAR(1)`	-

Table C-13 describes the DBA_CATALOG table.

Table C-13 DBA_CATALOG

Name	Null?	Type	Value
`OWNER`	`NOT NULL`	`VARCHAR2(30)`	`IMS`
`TABLE_NAME`	`NOT NULL`	`VARCHAR2(30)`	-
`TABLE_TYPE`	-	`VARCHAR2(11)`	"`TABLE`"

Table C-14 describes the DBA_OBJECTS table.

Table C-14 DBA_OBJECTS

Name	Null?	Type	Value
`OWNER`	-	`VARCHAR2(30)`	`IMS`
`OBJECT_NAME`	-	`VARCHAR2(128)`	-
`SUBOBJECT_NAME`	-	`VARCHAR2(1)`	`NULL`
`OBJECT_ID`	-	`NUMBER`	`0`
`DATA_OBJECT_ID`	-	`NUMBER`	`0`
`OBJECT_TYPE`	-	`VARCHAR2(18)`	"`TABLE`" or "`INDEX`"
`CREATED`	-	`DATE`	`NULL`
`LAST_DDL_TIME`	-	`DATE`	`NULL`
`TIMESTAMP`	-	`VARCHAR2(1)`	`NULL`
`STATUS`	-	`VARCHAR2(1)`	`NULL`
`TEMPORARY`	-	`VARCHAR2(1)`	`NULL`
`GENERATED`	-	`VARCHAR2(1)`	`NULL`
`SECONDARY`	-	`VARCHAR2(1)`	`NULL`

Table C-15 describes the DBA_TAB_COLUMNS table.

Table C-15 DBA_TAB_COLUMNS

Name	Null?	Type	Value
`OWNER`	`NOT NULL`	`VARCHAR2(30)`	`IMS`
`TABLE_NAME`	`NOT NULL`	`VARCHAR2(30)`	-
`COLUMN_NAME`	`NOT NULL`	`VARCHAR2(30)`	-
`DATA_TYPE`	-	`VARCHAR2(106)`	-
`DATA_TYPE_MOD`	`NOT NULL`	`CHAR(1)`	-
`DATA_TYPE_OWNER`	`NOT NULL`	`CHAR(1)`	-
`DATA_LENGTH`	`NOT NULL`	`FLOAT(49)`	-
`DATA_PRECISION`	-	`FLOAT(49)`	-
`DATA_SCALE`	-	`FLOAT(49)`	-
`NULLABLE`	-	`VARCHAR2(1)`	"Y" or "N"
`COLUMN_ID`	`NOT NULL`	`FLOAT(49)`	-
`DEFAULT_LENGTH`	`NOT NULL`	`NUMBER(10)`	0
`DATA_DEFAULT`	`NOT NULL`	`CHAR(1)`	-
`NUM_DISTINCT`	`NOT NULL`	`NUMBER(10)`	0
`LOW_VALUE`	`NOT NULL`	`NUMBER(10)`	-
`HIGH_VALUE`	`NOT NULL`	`NUMBER(10)`	-
`DENSITY`	`NOT NULL`	`NUMBER(10)`	`0`
`NUM_NULLS`	`NOT NULL`	`NUMBER(10)`	`0`
`NUM_BUCKETS`	`NOT NULL`	`NUMBER(10)`	`0`
`LAST_ANALYZED`	-	`DATE`	`NULL`
`SAMPLE_SIZE`	`NOT NULL`	`NUMBER(10)`	`0`
`CHARACTER_SET_NAME`	`NOT NULL`	`CHAR(1)`	-
`CHAR_COL_DEC_LENGTH`	`NOT NULL`	`NUMBER(10)`	`0`
`GLOBAL_STATS`	`NOT NULL`	`CHAR(1)`	-
`USER_STATS`	`NOT NULL`	`CHAR(1)`	-
`AVG_COL_LEN`	`NOT NULL`	`NUMBER(10)`	`0`

Table C-16 describes the DICT_COLUMNS table.

Table C-16 DICT_COLUMNS

Name	Null?	Type	Value
`TABLE_NAME`	`NOT NULL`	`VARCHAR2(30)`	-
`COLUMN_NAME`	`NOT NULL`	`VARCHAR2(30)`	-
`COMMENTS`	`NOT NULL`	`CHAR(1)`	-

Table C-17 describes the DICTIONARY table.

Table C-17 DICTIONARY

Name	Null?	Type	Value
`TABLE_NAME`	`NOT NULL`	`VARCHAR2(30)`	-
`COMMENTS`	`NOT NULL`	`CHAR(1)`	-

Table C-18 describes the DUAL table.

Table C-18 DUAL

Name	Null?	Type	Value
`DUMMY`	`NOT NULL`	`VARCHAR2(1`)	-

Table C-19 describes the USER_CATALOG table.

Table C-19 USER_CATALOG

Name	Null?	Type	Value
`TABLE_NAME`	`NOT NULL`	`VARCHAR2(30)`	-
`TABLE_TYPE`	-	`VARCHAR2(11)`	"`TABLE`"

Table C-20 describes the USER_COL_COMMENTS table.

Table C-20 USER_COL_COMMENTS

Name	Null?	Type	Value
`TABLE_NAME`	`NOT NULL`	`VARCHAR2(30)`	-
`COLUMN_NAME`	`NOT NULL`	`VARCHAR2(30)`	-
`COMMENTS`	`NOT NULL`	`CHAR(1)`	-

Table C-21 describes the USER_CONS_COLUMNS table.

Table C-21 USER_CONS_COLUMNS

Name	Null?	Type	Value
`OWNER`	`NOT NULL`	`VARCHAR2(30)`	`IMS`
`CONSTRAINT_NAME`	`NOT NULL`	`VARCHAR2(30)`	-
`TABLE_NAME`	`NOT NULL`	`VARCHAR2(30)`	-
`COLUMN_NAME`	-	`VARCHAR2(4000)`	-
`POSITION`	-	`FLOAT(49)`	-

Table C-22 describes the USER_CONSTRAINTS table.

Table C-22 USER_CONSTRAINTS

Name	Null?	Type	Value
`OWNER`	`NOT NULL`	`VARCHAR2(30)`	`IMS`
`CONSTRAINT_NAME`	`NOT NULL`	`VARCHAR2(30)`	-
`CONSTRAINT_TYPE`	-	`VARCHAR2(1)`	"`R`" or "`P`"
`TABLE_NAME`	-	`VARCHAR2(30)`	-
`SEARCH_CONDITION`	`NOT NULL`	`CHAR(1)`	-
`R_OWNER`	`NOT NULL`	`VARCHAR2(1)`	-
`R_CONSTRAINT_NAME`	-	`VARCHAR2(30)`	-
`DELETE_RULE`	-	`VARCHAR2(9)`	`NULL`
`STATUS`	`NOT NULL`	`CHAR(1)`	-
`DEFERRABLE`	`NOT NULL`	`CHAR(1)`	-
`DEFERRED`	`NOT NULL`	`CHAR(1)`	-
`VALIDATED`	`NOT NULL`	`CHAR(1)`	-
`GENERATED`	`NOT NULL`	`CHAR(1)`	-
`BAD`	`NOT NULL`	`CHAR(1)`	-
`RELY`	`NOT NULL`	`CHAR(1)`	-
`LAST_CHANGE`	-	`DATE`	`NULL`

Table C-23 describes the USER_IND_COLUMNS table.

Table C-23 USER_IND_COLUMNS

Name	Null?	Type	Value
`INDEX_NAME`	`NOT NULL`	`VARCHAR2(30)`	-
`TABLE_NAME`	`NOT NULL`	`VARCHAR2(30)`	-
`COLUMN_NAME`	-	`VARCHAR2(4000)`	-
`COLUMN_POSITION`	`NOT NULL`	`FLOAT(49)`	-
`COLUMN_LENGTH`	`NOT NULL`	`FLOAT(49)`	-
`DESCEND`	-	`VARCHAR2(4)`	"`DESC`" or "`ASC`"

Table C-24 describes the USER_INDEXES table.

Table C-24 USER_INDEXES

Name	Null?	Type	Value
`INDEX_NAME`	`NOT NULL`	`VARCHAR2(30)`	-
`INDEX_TYPE`	`NOT NULL`	`CHAR(1)`	-
`TABLE_OWNER`	`NOT NULL`	`VARCHAR2(30)`	-
`TABLE_NAME`	`NOT NULL`	`VARCHAR2(30)`	-
`TABLE_TYPE`	`NOT NULL`	`CHAR(5)`	"`TABLE`"
`UNIQUENESS`	-	`VARCHAR2(9)`	"`UNIQUE`" or "`NONUNIQUE`"
`COMPRESSION`	`NOT NULL`	`CHAR(1)`	-
`PREFIX_LENGTH`	`NOT NULL`	`NUMBER(10)`	`0`
`TABLESPACE_NAME`	`NOT NULL`	`CHAR(1)`	-
`INI_TRANS`	`NOT NULL`	`NUMBER(10)`	`0`
`MAX_TRANS`	`NOT NULL`	`NUMBER(10)`	`0`
`INITIAL_EXTENT`	`NOT NULL`	`NUMBER(10)`	`0`
`NEXT_EXTENT`	`NOT NULL`	`NUMBER(10)`	`0`
`MIN_EXTENTS`	`NOT NULL`	`NUMBER(10)`	`0`
`MAX_EXTENTS`	`NOT NULL`	`NUMBER(10)`	`0`
`PCT_INCREASE`	`NOT NULL`	`NUMBER(10)`	`0`
`PCT_THRESHOLD`	`NOT NULL`	`NUMBER(10)`	`0`
`INCLUDE_COLUMN`	`NOT NULL`	`NUMBER(10)`	`0`
`FREELISTS`	`NOT NULL`	`NUMBER(10)`	`0`
`FREELIST_GROUPS`	`NOT NULL`	`NUMBER(10)`	`0`
`PCT_FREE`	`NOT NULL`	`NUMBER(10)`	`0`
`LOGGING`	`NOT NULL`	`CHAR(1)`	-
`BLEVEL`	`NOT NULL`	`NUMBER(10)`	`0`
`LEAF_BLOCKS`	`NOT NULL`	`NUMBER(10)`	`0`
`DISTINCT_KEYS`	-	`FLOAT(49)`	-
`AVG_LEAF_BLOCKS_PER_KEY`	`NOT NULL`	`NUMBER(10)`	`0`
`AVG_DATA_BLOCKS_PER_KEY`	`NOT NULL`	`NUMBER(10)`	`0`
`CLUSTERING_FACTOR`	`NOT NULL`	`NUMBER(10)`	`0`
`STATUS`	`NOT NULL`	`CHAR(1)`	-
`NUM_ROWS`	`NOT NULL`	`NUMBER(10)`	`0`
`SAMPLE_SIZE`	`NOT NULL`	`NUMBER(10)`	`0`
`LAST_ANALYZED`	-	`DATE`	`NULL`
`DEGREE`	`NOT NULL`	`CHAR(1)`	-
`INSTANCES`	`NOT NULL`	`CHAR(1)`	-
`PARTITIONED`	`NOT NULL`	`CHAR(1)`	-
`TEMPORARY`	`NOT NULL`	`CHAR(1)`	-
`GENERATED`	`NOT NULL`	`CHAR(1)`	-
`SECONDARY`	`NOT NULL`	`CHAR(1)`	-
`BUFFER_POOL`	`NOT NULL`	`CHAR(1)`	-
`USER_STATS`	`NOT NULL`	`CHAR(1)`	-
`DURATION`	`NOT NULL`	`CHAR(1)`	-
`PCT_DIRECT_ACCESS`	`NOT NULL`	`NUMBER(10)`	`0`
`ITYP_OWNER`	`NOT NULL`	`CHAR(1)`	-
`ITYP_NAME`	`NOT NULL`	`CHAR(1)`	-
`PARAMETERS`	`NOT NULL`	`CHAR(1)`	-
`GLOBAL_STATS`	`NOT NULL`	`CHAR(1)`	-
`DOMIDX_STATUS`	`NOT NULL`	`CHAR(1)`	-
`DOMIDX_OPSTATUS`	`NOT NULL`	`CHAR(1)`	-
`FUNCIDX_STATUS`	`NOT NULL`	`CHAR(1)`	-

Table C-25 describes the USER_OBJECTS table.

Table C-25 USER_OBJECTS

Name	Null?	Type	Value
`OBJECT_NAME`	-	`VARCHAR2(128)`	-
`SUBOBJECT_NAME`	-	`VARCHAR2(1)`	`NULL`
`OBJECT_ID`	-	`NUMBER`	`0`
`DATA_OBJECT_ID`	-	`NUMBER`	`0`
`OBJECT_TYPE`	-	`VARCHAR2(18)`	"`TABLE`" or "`INDEX`"
`CREATED`	-	`DATE`	`NULL`
`LAST_DDL_TIME`	-	`DATE`	`NULL`
`TIMESTAMP`	-	`VARCHAR2(1)`	`NULL`
`STATUS`	-	`VARCHAR2(1)`	`NULL`
`TEMPORARY`	-	`VARCHAR2(1)`	`NULL`
`GENERATED`	-	`VARCHAR2(1)`	`NULL`
`SECONDARY`	-	`VARCHAR2(1)`	`NULL`

Table C-26 describes the USER_TAB_COLUMNS table.

Table C-26 USER_TAB_COLUMNS

Name	Null?	Type	Value
`TABLE_NAME`	`NOT NULL`	`VARCHAR2(30)`	-
`COLUMN_NAME`	`NOT NULL`	`VARCHAR2(30)`	-
`DATA_TYPE`	-	`VARCHAR2(106)`	-
`DATA_TYPE_MOD`	`NOT NULL`	`CHAR(1)`	-
`DATA_TYPE_OWNER`	`NOT NULL`	`CHAR(1)`	-
`DATA_LENGTH`	`NOT NULL`	`FLOAT(49)`	-
`DATA_PRECISION`	-	`FLOAT(49)`	-
`DATA_SCALE`	-	`FLOAT(49)`	-
`NULLABLE`	-	`VARCHAR2(1)`	"`Y`" or "`N`"
`COLUMN_ID`	`NOT NULL`	`FLOAT(49)`	-
`DEFAULT_LENGTH`	`NOT NULL`	`NUMBER(10)`	`0`
`DATA_DEFAULT`	`NOT NULL`	`CHAR(1)`	-
`NUM_DISTINCT`	`NOT NULL`	`NUMBER(10)`	`0`
`LOW_VALUE`	`NOT NULL`	`NUMBER(10)`	`0`
`HIGH_VALUE`	`NOT NULL`	`NUMBER(10)`	`0`
`DENSITY`	`NOT NULL`	`NUMBER(10)`	`0`
`NUM_NULLS`	`NOT NULL`	`NUMBER(10)`	`0`
`NUM_BUCKETS`	`NOT NULL`	`NUMBER(10)`	`0`
`LAST_ANALYZED`	-	`DATE`	`NULL`
`SAMPLE_SIZE`	`NOT NULL`	`NUMBER(10)`	`0`
`CHARACTER_SET_NAME`	`NOT NULL`	`CHAR(1)`	-
`CHAR_COL_DECL_LENGTH`	`NOT NULL`	`NUMBER(10)`	`0`
`GLOBAL_STATS`	`NOT NULL`	`CHAR(1)`	-
`USER_STATS`	`NOT NULL`	`CHAR(1)`	-
`AVG_COL_LEN`	`NOT NULL`	`NUMBER(10)`	`0`

Table C-27 describes the USER_TAB_COMMENTS table.

Table C-27 USER_TAB_COMMENTS

Name	Null?	Type	Value
`TABLE_NAME`	`NOT NULL`	`VARCHAR2(30)`	-
`TABLE_TYPE`	-	`VARCHAR2(11)`	"`TABLE`"
`COMMENTS`	`NOT NULL`	`CHAR(1)`	-

Table C-28 describes the USER_TABLES table.

Table C-28 USER_TABLES

Name	Null?	Type	Value
`TABLE_NAME`	`NOT NULL`	`VARCHAR2(30)`	-
`TABLESPACE_NAME`	`NOT NULL`	`CHAR(1)`	-
`CLUSTER_NAME`	`NOT NULL`	`CHAR(1)`	-
`IOT_NAME`	`NOT NULL`	`CHAR(1)`	-
`PCT_FREE`	`NOT NULL`	`NUMBER(10)`	`0`
`PCT_USED`	`NOT NULL`	`NUMBER(10)`	`0`
`INI_TRANS`	`NOT NULL`	`NUMBER(10)`	`0`
`MAX_TRANS`	`NOT NULL`	`NUMBER(10)`	`0`
`INITIAL_EXTENT`	`NOT NULL`	`NUMBER(10)`	`0`
`NEXT_EXTENT`	`NOT NULL`	`NUMBER(10)`	`0`
`MIN_EXTENTS`	`NOT NULL`	`NUMBER(10)`	`0`
`MAX_EXTENTS`	`NOT NULL`	`NUMBER(10)`	`0`
`PCT_INCREASE`	`NOT NULL`	`NUMBER(10)`	`0`
`FREELISTS`	`NOT NULL`	`NUMBER(10)`	`0`
`FREELIST_GROUPS`	`NOT NULL`	`NUMBER(10)`	`0`
`LOGGING`	`NOT NULL`	`CHAR(1)`	-
`BACKED_UP`	`NOT NULL`	`CHAR(1)`	-
`NUM_ROWS`	-	`FLOAT(49)`	-
`BLOCKS`	-	`FLOAT(49)`	-
`EMPTY_BLOCKS`	`NOT NULL`	`NUMBER(10)`	`0`
`AVG_SPACE`	`NOT NULL`	`NUMBER(10)`	`0`
`CHAIN_CNT`	`NOT NULL`	`NUMBER(10)`	`0`
`AVG_ROW_LEN`	`NOT NULL`	`NUMBER(10)`	`0`
`AVG_SPACE_FREELIST_BLOCKS`	`NOT NULL`	`NUMBER(10)`	`0`
`NUM_FREELIST_BLOCKS`	`NOT NULL`	`NUMBER(10)`	`0`
`DEGREE`	`NOT NULL`	`CHAR(1)`	-
`INSTANCES`	`NOT NULL`	`CHAR(1)`	-
`CACHE`	`NOT NULL`	`CHAR(1)`	-
`TABLE_LOCK`	`NOT NULL`	`CHAR(1)`	-
`SAMPLE_SIZE`	`NOT NULL`	`NUMBER(10)`	`0`
`LAST_ANALYZED`	-	`DATE`	`NULL`
`PARTITIONED`	`NOT NULL`	`CHAR(1)`	-
`IOT_TYPE`	`NOT NULL`	`CHAR(1)`	-
`TEMPORARY`	`NOT NULL`	`CHAR(1)`	-
`SECONDARY`	`NOT NULL`	`CHAR(1)`	-
`NESTED`	`NOT NULL`	`CHAR(1)`	-
`BUFFER_POOL`	`NOT NULL`	`CHAR(1)`	-
`ROW_MOVEMENT`	`NOT NULL`	`CHAR(1)`	-
`GLOBAL_STATS`	`NOT NULL`	`CHAR(1)`	-
`USER_STATS`	`NOT NULL`	`CHAR(1)`	-
`DURATION`	`NOT NULL`	`CHAR(1)`	-
`SKIP_CORRUPT`	`NOT NULL`	`CHAR(1)`	-
`MONITORING`	`NOT NULL`	`CHAR(1)`	-

Table C-29 describes the USER_USERS table.

Table C-29 USER_USERS

Name	Null?	Type	Value
`USERNAME`	`NOT NULL`	`VARCHAR2(30)`	-
`USER_ID`	-	`NUMBER`	`0`
`ACCOUNT_STATUS`	-	`VARCHAR2(4)`	"`OPEN`"
`LOCK_DATE`	-	`DATE`	`NULL`
`EXPIRY_DATE`	-	`DATE`	`NULL`
`DEFAULT_TABLESPACE`	-	`VARCHAR2(1)`	`NULL`
`TEMPORARY_TABLESPACE`	-	`VARCHAR2(1)`	`NULL`
`CREATED`	-	`DATE`	`NULL`
`INITIAL_RSRC_CONSUMER_GROUP`	-	`VARCHAR2(1)`	`NULL`
`EXTERNAL_NAME`	-	`VARCHAR2(1)`	`NULL`

Table C-30 describes the USER_VIEWS table.

Table C-30 USER_VIEWS

Name	Null?	Type	Value
`VIEW_NAME`	`NOT NULL`	`VARCHAR2(30)`	-
`TEXT_LENGTH`	`NOT NULL`	`NUMBER(10)`	0
`TEXT`	`NOT NULL`	`CHAR(1)`	-
`TYPE_TEXT_LENGTH`	`NOT NULL`	`NUMBER(10)`	0
`TYPE_TEXT`	`NOT NULL`	`CHAR(1)`	-
`OID_TEXT_LENGTH`	`NOT NULL`	`NUMBER(10)`	0
`OID_TEXT`	`NOT NULL`	`CHAR(1)`	-
`VIEW_TYPE_OWNER`	`NOT NULL`	`CHAR(1)`	-
`VIEW_TYPE`	`NOT NULL`	`CHAR(1)`	-