C
Data Dictionary

The Oracle Transparent Gateway for Ingres II translates a query that refers to an Oracle database server data dictionary table into a query that retrieves the data from Ingres II system tables. 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

Ingres II System Tables

Ingres II data dictionary information is stored in the Ingres II database as Ingres II system tables. All Ingres II system tables have names prefixed with "sys". The Ingres II system tables define the structure of a database. When you change data definitions, Ingres II reads and modifies the Ingres II system tables to add information about the user tables.

Accessing the Gateway Data Dictionary

Accessing a gateway data dictionary table or view is identical to accessing a data dictionary in 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 in an Oracle database. Synonyms of supported views are also acceptable. For example, the following statement queries the data dictionary table ALL_CATALOG to retrieve all table names in the Ingres II database:

SQL> SELECT * FROM "ALL_CATALOG"@INGR;

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

Maps the requested table, view, or synonym to one or more Ingres II system table names. The gateway translates all data dictionary column names to their corresponding Ingres II column names within the query. If the mapping involves one Ingres II system table, the gateway translates the requested table name to its corresponding Ingres II system table name within the query. If the mapping involves multiple Ingres II system tables, the gateway constructs a join in the query using the translated Ingres II system table names.
Sends the translated query to Ingres II.
Might convert the retrieved Ingres II data to give it the appearance of the Oracle database server data dictionary table.
Passes the data dictionary information from the translated Ingres II system table to the Oracle database server.

Note:
The values returned when querying the gateway data dictionary might not be the same as the ones returned by the Oracle SQL*Plus DESCRIBE command.

Direct Queries to Ingres II Tables

Queries issued directly to individual Ingres II system tables are allowed but they return different results because the Ingres II system table column names differ from those of the data dictionary view. Also, certain columns in an Ingres II system table cannot be used in data dictionary processing.

Supported Views and Tables

The gateway supports the following views and tables:

ALL_CATALOG

ALL_COL_COMMENTS

ALL_CONS_COLUMNS

ALL_CONSTRAINTS

ALL_INDEXES

ALL_OBJECTS

ALL_SYNONYMS

ALL_TAB_COLUMNS

ALL_TAB_COMMENTS

ALL_TABLES

ALL_USERS

ALL_VIEWS

DBA_CATALOG

DBA_COL_COMMENTS

DBA_OBJECTS

DBA_TAB_COLUMNS

DBA_TAB_COMMENTS

DBA_TABLES

DICT_COLUMNS

DICTIONARY

DUAL

TABLE_PRIVILEGES

USER_CATALOG

USER_COL_COMMENTS

USER_CONS_COLUMNS

USER_CONSTRAINTS

USER_INDEXES

USER_OBJECTS

USER_SYNONYMS

USER_TAB_COLUMNS

USER_TAB_COMMENTS

USER_TABLES

USER_USERS

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.

Queries through the gateway of any data dictionary table or view beginning with ALL_ can returns rows from the Ingres II database even when access privileges for those Ingres II 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.

Data Dictionary Mapping

The tables in this section list Oracle data dictionary view names and the equivalent Ingres II system tables used. A plus sign (+) indicates that a join operation is involved.

Table C-1 Oracle Data Dictionary View Names and Ingres II Equivalents

View Name	Ingres II System Table Name
ALL_CATALOG	iitables
ALL_COL_COMMENTS	iicolumns+iitables
ALL_CONS_COLUMNS	iikeys
ALL_CONSTRAINTS	iiconstraints+iiref-constraints
ALL_INDEXES	iiindexes
ALL_OBJECTS	iitables+iiprocedures
ALL_SYNONYMS	iisynonyms
ALL_TAB_COLUMNS	iicolumns+iitables
ALL_TAB_COMMENTS	iitables
ALL_TABLES	iitables
ALL_USERS	iitables
ALL_VIEWS	iiviews
DBA_CATALOG	iitables
DBA_COL_COMMENTS	iicolumns+iitables
DBA_OBJECTS	iitables+iiprocedures
DBA_TAB_COLUMNS	iicolumns+iitables
DBA_TAB_COMMENTS	iitables
DBA_TABLES	iitables
DICT_COLUMNS	iicolumns+iitables
DICTIONARY	iitables
DUAL	(Defined in the Gateway)
TABLE_PRIVILEGES	iipermits
USER_CATALOG	iitables
USER_COL_COMMENTS	iicolumns+iitables
USER_CONS_COLUMNS	iicolumns+iitables
USER_CONSTRAINTS	iicolumns+iiintegrities+iitables
USER_INDEXES	iiindexes
USER_OBJECTS	iitables+iiprocedures
USER_SYNONYMS	iisynonyms
USER_TAB_COLUMNS	iicolumns+iitables
USER_TAB_COMMENTS	iitables
USER_TABLES	iitables
USER_USERS	iitables
USER_VIEWS	iiviews

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 Ingres II system table are filled with zeros, spaces, null values, not-applicable values (N.A.), or default values, depending on the column type.

Gateway Data Dictionary Descriptions

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

Name, data type, and width of each column
The contents of columns with fixed values

They are described here with information retrieved by an Oracle SQL*Plus DESCRIBE command. The values in the Null? column might differ from the Oracle database server data dictionary tables and views. Any default value is shown to the right of an item, but this is not information returned by DESCRIBE.

Table C-2 ALL_CATALOG

Name	Null?	Type	Value
OWNER	-	VARCHAR2(30)	-
TABLE_NAME	-	VARCHAR2(30)	-
TABLE_TYPE	-	VARCHAR2(5)	"TABLE" or "VIEW"

Table C-3 ALL_COL_COMMENTS

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

Table C-4 ALL_CONS_COLUMNS

Name	Null?	Type	Value
OWNER	-	VARCHAR2(30)	-
CONSTRAINT_NAME	-	VARCHAR2(30)	-
TABLE_NAME	-	VARCHAR2(30)	-
COLUMN_NAME	-	VARCHAR2(30)	-
POSITION	NOT NULL	NUMBER(5)	-

Table C-5 ALL_CONSTRAINTS

Name	Null?	Type	Value
OWNER	-	VARCHAR2(30)	-
CONSTRAINT_NAME	-	VARCHAR2(30)	-
CONSTRAINT_TYPE	-	VARCHAR2(1)	"R" or "P" or "U" or "C"
TABLE_NAME	-	VARCHAR2(30)	-
SEARCH_CONDITION	-	VARCHAR2(240)	-
R_OWNER	-	VARCHAR2(30)	-
R_CONSTRAINT_NAME	-	VARCHAR2(30)	-
DELETE_RULE	-	VARCHAR2(1)	NULL
STATUS	-	VARCHAR2(7)	"ENABLED"
DEFERRABLE	-	VARCHAR2(1)	NULL
DEFERRED	-	VARCHAR2(1)	NULL
VALIDATED	-	VARCHAR2(1)	NULL
GENERATED	-	VARCHAR2(1)	NULL
BAD	-	VARCHAR2(1)	NULL
RELY	-	VARCHAR2(1)	NULL
LAST_CHANGE	-	DATE	Date returned in Greenwich Mean Time (GMT)

Table C-6 ALL_INDEXES

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

Table C-7 ALL_OBJECTS

Name	Null?	Type	Value
OWNER	-	VARCHAR2(30)	-
OBJECT_NAME	-	VARCHAR2(30)	-
SUBOBJECT_NAME	-	VARCHAR2(1)	NULL
OBJECT_ID	-	NUMBER	-
DATA_OBJECT_ID	-	NUMBER	0
OBJECT_TYPE	-	VARCHAR2(9)	"TABLE" or "VIEW" or "INDEX" or "PROCEDURE"
CREATED	-	DATE	Date returned in Greenwich Mean Time (GMT)
LAST_DDL_TIME	-	DATE	Date returned in Greenwich Mean Time (GMT)
TIMESTAMP	-	VARCHAR2(1)	NULL
STATUS	-	VARCHAR2(5)	"VALID"
TEMPORARY	-	VARCHAR2(1)	NULL
GENERATED	-	VARCHAR2(1)	NULL
SECONDARY	-	VARCHAR2(1)	NULL

Table C-8 ALL_SYNONYMS

Name	Null?	Type	Value
OWNER	-	VARCHAR2(30)	-
SYNONYM_NAME	-	VARCHAR2(30)	-
TABLE_OWNER	-	VARCHAR2(30)	-
TABLE_NAME	-	VARCHAR2(30)	-
DB_LINK	-	VARCHAR2(1)	NULL

Table C-9 ALL_TAB_COLUMNS

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

Table C-10 ALL_TAB_COMMENTS

Name	Null?	Type	Value
OWNER	-	VARCHAR2(30)	-
TABLE_NAME	-	VARCHAR2(30)	-
TABLE_TYPE	-	VARCHAR2(5)	"TABLE" or "VIEW"
COMMENTS	-	VARCHAR2(1)	NULL

Table C-11 ALL_TABLES

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

Table C-12 ALL_USERS

Name	Null?	Type	Value
USERNAME	-	VARCHAR2(30)	-
USER_ID	-	NUMBER	-
CREATED	-	DATE	SYSDATE

Table C-13 ALL_VIEWS

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

Table C-14 DBA_CATALOG

Name	Null?	Type	Value
OWNER	-	VARCHAR2(30)	-
TABLE_NAME	-	VARCHAR2(30)	-
TABLE_TYPE	-	VARCHAR2(5)	"TABLE" or "VIEW"

Table C-15 DBA_COL_COMMENTS

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

Table C-16 DBA_OBJECTS

Name	Null?	Type	Value
OWNER	-	VARCHAR2(30)	-
OBJECT_NAME	-	VARCHAR2(30)	-
SUBOBJECT_NAME	-	VARCHAR2(1)	NULL
OBJECT_ID	-	NUMBER	-
DATA_OBJECT_ID	-	NUMBER	0
OBJECT_TYPE	-	VARCHAR2(9)	"TABLE" or "VIEW" or "INDEX" or "PROCEDURE"
CREATED	-	DATE	Date returned in Greenwich Mean Time (GMT)
LAST_DDL_TIME	-	DATE	Date returned in Greenwich Mean Time (GMT)
TIMESTAMP	-	VARCHAR2(1)	NULL
STATUS	-	VARCHAR2(5)	"VALID"
TEMPORARY	-	VARCHAR2(1)	NULL
GENERATED	-	VARCHAR2(1)	NULL
SECONDARY	-	VARCHAR2(1)	NULL

Table C-17 DBA_TAB_COLUMNS

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

Table C-18 DBA_TAB_COMMENTS

Name	Null?	Type	Value
OWNER	-	VARCHAR2(30)	-
TABLE_NAME	-	VARCHAR2(30)	-
TABLE_TYPE	-	VARCHAR2(5)	"TABLE" or "VIEW"
COMMENTS	-	VARCHAR2(1)	NULL

Table C-19 DBA_TABLES

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

Table C-20 DICT_COLUMNS

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

Table C-21 DICTIONARY

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

Table C-22 DUAL

Name	Null?	Type	Value
DUMMY	NOT NULL	VARCHAR2(1)	"X"

Table C-23 TABLE_PRIVILEGES

Name	Null?	Type	Value
GRANTEE	-	VARCHAR2(30)	-
OWNER	-	VARCHAR2(30)	-
TABLE_NAME	-	VARCHAR2(30)	-
GRANTOR	-	VARCHAR2(30)	-
SELECT_PRIV	-	VARCHAR2(1)	NULL
INSERT_PRIV	-	VARCHAR2(1)	NULL
DELETE_PRIV	-	VARCHAR2(1)	NULL
UPDATE_PRIV	-	VARCHAR2(1)	NULL
REFERENCES_PRIV	-	VARCHAR2(1)	NULL
ALTER_PRIV	-	VARCHAR2(1)	NULL
INDEX_PRIV	-	VARCHAR2(1)	NULL
CREATED	-	DATE	SYSDATE

Table C-24 USER_CATALOG

Name	Null?	Type	Value
TABLE_NAME	-	VARCHAR2(30)	-
TABLE_TYPE	-	VARCHAR2(5)	"TABLE" or "VIEW"

Table C-25 USER_COL_COMMENTS

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

Table C-26 USER_CONS_COLUMNS

Name	Null?	Type	Value
OWNER	-	VARCHAR2(30)	-
CONSTRAINT_NAME	-	VARCHAR2(30)	-
TABLE_NAME	-	VARCHAR2(30)	-
COLUMN_NAME	-	VARCHAR2(30)	-
POSITION	NOT NULL	NUMBER(5)	-

Table C-27 USER_CONSTRAINTS

Name	Null?	Type	Value
OWNER	-	VARCHAR2(30)	-
CONSTRAINT_NAME	-	VARCHAR2(30)	-
CONSTRAINT_TYPE	-	VARCHAR2(1)	"R" or "P" or "U" or "C"
TABLE_NAME	-	VARCHAR2(30)	-
SEARCH_CONDITION	-	VARCHAR2(240)	-
R_OWNER	-	VARCHAR2(30)	-
R_CONSTRAINT_NAME	-	VARCHAR2(30)
DELETE_RULE	-	VARCHAR2(1)	NULL
STATUS	-	VARCHAR2(7)	"ENABLED"
DEFERRABLE	-	VARCHAR2(1)	NULL
DEFERRED	-	VARCHAR2(1)	NULL
VALIDATED	-	VARCHAR2(1)	NULL
GENERATED	-	VARCHAR2(1)	NULL
BAD	-	VARCHAR2(1)	NULL
RELY	-	VARCHAR2(1)	NULL
LAST_CHANGE	-	DATE	NULL

Table C-28 USER_INDEXES

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

Table C-29 USER_OBJECTS

Name	Null?	Type	Value
OBJECT_NAME	-	VARCHAR2(30)	-
SUBOBJECT_NAME	-	VARCHAR2(1)	NULL
OBJECT_ID	-	NUMBER	-
DATA_OBJECT_ID	-	NUMBER	0
OBJECT_TYPE	-	VARCHAR2(9)	"TABLE" or "VIEW" or "INDEX" or "PROCEDURE"
CREATED	-	DATE	Date returned in Greenwich Mean Time (GMT)
LAST_DDL_TIME	-	DATE	Date returned in Greenwich Mean Time (GMT)
TIMESTAMP	-	VARCHAR2(1)	NULL
STATUS	-	VARCHAR2(5)	"VALID"
TEMPORARY	-	VARCHAR2(1)	NULL
GENERATED	-	VARCHAR2(1)	NULL
SECONDARY	-	VARCHAR2(1)	NULL

Table C-30 USER_SYNONYMS

Name	Null?	Type	Value
OWNER	-	VARCHAR2(30)	-
SYNONYM_NAME	-	VARCHAR2(30)	-
TABLE_OWNER	-	VARCHAR2(30)	-
TABLE_NAME	-	VARCHAR2(30)	-
DB_LINK	-	VARCHAR2(1)	NULL

Table C-31 USER_TAB_COLUMNS

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

Table C-32 USER_TAB_COMMENTS

Name	Null?	Type	Value
TABLE_NAME	-	VARCHAR2(30)	-
TABLE_TYPE	-	VARCHAR2(5)	"TABLE" or "VIEW"
COMMENTS	-	VARCHAR2(1)	NULL

Table C-33 USER_TABLES

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

Table C-34 USER_USERS

Name	Null?	Type	Value
USERNAME	-	VARCHAR2(30)	-
USER_ID	-	NUMBER	-
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	SYSDATE
INITIAL_RSRC_CONSUMER_GROUP	-	VARCHAR2(1)	NULL
EXTERNAL_NAME	-	VARCHAR2(1)	NULL

Table C-35 USER_VIEWS

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

C Data Dictionary