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:

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:

  1. Maps the requested table, view, or synonym to one or more ADD names.

  2. Processes the query within the gateway.

  3. May convert the retrieved data to give it the appearance of the Oracle database server data dictionary table.

  4. 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.

See Also:

Oracle Database Error Messages for more information on error messages.

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)

-