B
Data Dictionary

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

Informix System Catalog Tables

Informix data dictionary information is stored in the Informix database as Informix system catalog tables. All Informix system catalog tables have names prefaced with "sys". The Informix system catalog tables define the structure of a database. When you change data definitions, Informix reads and modifies the Informix system catalog 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. Oracle 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 to retrieve all table names in the Informix database:

SQL> SELECT * FROM "ALL_TABLES"@IFMX;

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

Maps the requested table, view, or synonym to one or more Informix system table names. The gateway translates all data dictionary column names to their corresponding Informix column names within the query. If the mapping involves one Informix system table, the gateway translates the requested table name to its corresponding Informix system table name within the query. If the mapping involves multiple Informix system tables, the gateway constructs a join in the query using the translated Informix system table names.
Sends the translated query to Informix.
Might convert the retrieved Informix data to give it the appearance of the Oracle database server data dictionary table.
Passes the data dictionary information from the translated Informix 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 Enterprise Manager DESCRIBE command.

Direct Queries to Informix Tables

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

Supported Views and Tables

The gateway supports the following views and tables:

Table B-1 Gateway Supported Views and Tables

ALL_CATALOG	ALL_COL_COMMENTS
ALL_COL_PRIVS	ALL_CONS_COLUMNS
ALL_CONSTRAINTS	ALL_IND_COLUMNS
ALL_INDEXES	ALL_OBJECTS
ALL_SYNONYMS	ALL_TAB_COLUMNS
ALL_TAB_COMMENTS	ALL_TAB_PRIVS
ALL_TABLES	ALL_USERS
ALL_VIEWS	COLUMN_PRIVILEGES
DBA_CATALOG	DBA_COL_COMMENTS
DBA_OBJECTS	DBA_TABLES
DBA_TAB_COLUMNS	DBA_TAB_COMMENTS
DICT_COLUMNS	DICTIONARY
DUAL	TABLE_PRIVILEGES
USER_CATALOG	USER_COL_COMMENTS
USER_COL_PRIVS	USER_CONS_COLUMNS
USER_CONSTRAINTS	USER_IND_COLUMNS
USER_INDEXES	USER_OBJECTS
USER_SYNONYMS	USER_TAB_COLUMNS
USER_TAB_COMMENTS	USER_TAB_PRIVS
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 the supported data dictionary tables and views beginning with the characters "ALL_" might return rows from the Informix database when you do not have access privileges for those Informix objects. 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 Informix system table names. A plus sign (+) indicates that a join operation is involved.

Table B-2 Oracle Data Dictionary View Names and Informix Equivalents

View Name	Informix System Table Name
ALL_CATALOG	systables
ALL_COL_COMMENTS	systables +syscolumns
ALL_COL_PRIVS	systables + syscolumns + syscolauth
ALL_CONS_COLUMNS	systables + sysconstraints + syscolumns + syscoldepend
ALL_CONSTRAINTS	systables + sysconstraints
ALL_IND_COLUMNS	systables + sysindexes + syscolumns
ALL_INDEXES	sysindexes + systables
ALL_OBJECTS	systables + sysindexes + sysprocedures + sysprocplan
ALL_SYNONYMS	systables + syssynonyms + syssyntable
ALL_TAB_COLUMNS	systables + syscolumns
ALL_TAB_COMMENTS	systables
ALL_TAB_PRIVS	systables + systabauth
ALL_TABLES	systables
ALL_USERS	sysusers
ALL_VIEWS	systables + sysviews
COLUMN_PRIVILEGES	systables + syscolauth + syscolumns
DBA_CATALOG	systables
DBA_COL_COMMENTS	systables + syscolumns
DBA_OBJECTS	systables + sysindexes + sysprocedures + sysprocplan
DBA_TABLES	systables
DBA_TAB_COLUMNS	systables + syscolumns
DBA_TAB_COMMENTS	systables
DICT_COLUMNS	systables + syscolumns
DICTIONARY	systables
DUAL	Sysusers
TABLE_PRIVILEGES	systabauth + systables
USER_CATALOG	systables
USER_COL_COMMENTS	systables + syscolumns
USER_COL_PRIVS	systables + syscolumns + syscolauth
USER_CONS_COLUMNS	systables + sysconstraints + syscolumns + syscoldepend
USER_CONSTRAINTS	systables + sysconstraints
USER_IND_COLUMNS	systables + sysindexes + syscolumns
USER_INDEXES	systables + sysindexes
USER_OBJECTS	systables + sysindexes + sysprocedures + sysprocplan
USER_SYNONYMS	systables + syssynonyms + syssyntable
USER_TAB_COLUMNS	systables + syscolumns
USER_TAB_COMMENTS	systables
USER_TAB_PRIVS	systables + systabauth
USER_TABLES	systables
USER_USERS	sysusers
USER_VIEWS	systables + sysviews

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 a Informix data dictionary 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, datatype, and width of each column
The contents of columns with fixed values

They are described here with information retrieved by an Oracle Enterprise Manager 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 B-3 ALL_CATALOG

Name	Type	Value
OWNER	VARCHAR2(8)
TABLE_NAME	VARCHAR2(18)
TABLE_TYPE	VARCHAR2(7)	"TABLE" or "VIEW" or "SYNONYM"

Table B-4 ALL_COL_COMMENTS

Name	Null?	Type
OWNER		CHAR(8)
TABLE_NAME		CHAR(18)
COLUMN_NAME		CHAR(18)
COMMENTS	NOT NULL	CHAR(1)

Table B-5 ALL_COL_PRIVS

Name	Type	Value
GRANTOR	VARCHAR2 (8)
GRANTEE	VARCHAR2(8)
TABLE_SCHEMA	VARCHAR2(8)
TABLE_NAME	VARCHAR2(18)
COLUMN_NAME	VARCHAR2(18)
PRIVILEGE	VARCHAR2(10)	"SELECT" or "UPDATE" or "REFERENCES"
GRANTABLE	VARCHAR2(3)	"YES" or "NO"

Table B-6 ALL_CONS_COLUMNS

Name	Null?	Type	Value
OWNER		CHAR(8)
CONSTRAINT_NAME		CHAR(18)
TABLE_NAME		CHAR(18)
COLUMN_NAME		CHAR(18)
POSITION	NOT NULL	NUMBER(10)	0

Table B-7 ALL_CONSTRAINTS

Name	Null?	Type	Value
OWNER		CHAR(8)
CONSTRAINT_NAME		CHAR(18)
CONSTRAINT_TYPE		CHAR(1)	"R" or "P" or "U" or "C"
TABLE_NAME		CHAR(18)
SEARCH_CONDITION	NOT NULL	CHAR(1)
R_OWNER	NOT NULL	CHAR(1)
R_CONSTRAINT_NAME	NOT NULL	CHAR(1)
DELETE_RULE	NOT NULL	CHAR(1)
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

Table B-8 ALL_IND_COLUMNS

Name	Null?	Type	Value
INDEX_OWNER		CHAR(8)
INDEX_NAME		CHAR(18)
TABLE_OWNER		CHAR(8)
TABLE_NAME		CHAR(18)
COLUMN_NAME		CHAR(18)
COLUMN_POSITION	NOT NULL	NUMBER(10)	0
COLUMN_LENGTH	NOT NULL	NUMBER(10)	0
DESCEND	NOT NULL	CHAR(1)

Table B-9 ALL_INDEXES

Name	Type	Value
OWNER	VARCHAR2(8)
INDEX_NAME	VARCHAR2(18)
INDEX_TYPE	VARCHAR2(1)	NULL
TABLE_OWNER	VARCHAR2(8)
TABLE_NAME	VARCHAR2(18)
TABLE_TYPE	VARCHAR(5)	"TABLE"
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 B-10 ALL_OBJECTS

Name	Type	Value
OWNER	VARCHAR2(8)
OBJECT_NAME	VARCHAR2(18)
SUBOBJECT_NAME	VARCHAR2(1)	NULL
OBJECT_ID	NUMBER
DATA_OBJECT_ID	NUMBER	0
OBJECT_TYPE	VARCHAR2(9)	"TABLE" or "VIEW" or "SYNONYM" or "INDEX" or "PROCEDURE"
CREATED	DATE
LAST_DDL_TIME	VARCHAR2(0)	NULL
TIMESTAMP	VARCHAR2(1)	NULL
STATUS	VARCHAR2(1)	NULL
TEMPORARY	VARCHAR2(1)	NULL
GENERATED	VARCHAR2(1)	NULL
SECONDARY	VARCHAR2(1)	NULL

Table B-11 ALL_SYNONYMS

Name	Type	Value
OWNER	VARCHAR2(8)
SYNONYM_NAME	VARCHAR2(18)
TABLE_OWNER	VARCHAR2(8)
TABLE_NAME	VARCHAR2(18)
DB_LINK	VARCHAR2(1)	NULL

Table B-12 ALL_TAB_COLUMNS

Name	Type	Value
OWNER	VARCHAR2(8)
TABLE_NAME	VARCHAR2(18)
COLUMN_NAME	VARCHAR2(18)
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	VARCHAR2(1)	"Y" or "N"
COLUMN_ID	NUMBER(5)
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	VARCHAR2(0)	NULL
SAMPLE_SIZE	NUMBER	0
CHARACTER_SET_NAME	VARCHAR2(1)	NULL
CHAR_COL_DEC_LENGTH	NUMBER	0
GLOBAL_STATS	VARCHAR2(1)	NULL
USER_STATS	VARCHAR2(1)	NULL
AVG_COL_LEN	NUMBER	0

Table B-13 ALL_TAB_COMMENTS

Name	Type	Value
OWNER	VARCHAR2(8)
TABLE_NAME	VARCHAR2(18)
TABLE_TYPE	VARCHAR2(5)	"TABLE" or "VIEW"
COMMENTS	VARCHAR2(1)	NULL

Table B-14 ALL_TAB_PRIVS

Name	Type	Value
GRANTOR	VARCHAR2(8)
GRANTEE	VARCHAR2(8)
TABLE_SCHEMA	VARCHAR2(8)
TABLE_NAME	VARCHAR2(18)
PRIVILEGE	VARCHAR2(10)	"SELECT" or "UPDATE" or "INSERT" or "DELETE" or "INDEX" or "ALTER" or "REFERENCES"
GRANTABLE	VARCHAR2 (3)	"YES"

Table B-15 ALL_TABLES

Name	Type	Value
OWNER	VARCHAR2(8)
TABLE_NAME	VARCHAR2(18)
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(10)
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	VARCHAR2(0)	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 B-16 ALL_USERS

Name	Type	Value
USERNAME	VARCHAR2(8)
USER_ID	NUMBER	0
CREATED	VARCHAR2(0)	NULL

Table B-17 ALL_VIEWS

Name	Null?	Type	Value
OWNER		CHAR(8)
VIEW_NAME		CHAR(18)
TEXT_LENGTH	NOT NULL	NUMBER(10)	64
TEXT		CHAR(64)
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 B-18 COLUMN_PRIVILEGES

Name	Type	Value
GRANTEE	VARCHAR2(8)
OWNER	VARCHAR2(8)
TABLE_NAME	VARCHAR2(18)
COLUMN_NAME	VARCHAR2(18)
GRANTOR	VARCHAR2(8)
INSERT_PRIV	VARCHAR2(1)	"Y"
UPDATE_PRIV	VARCHAR2(1)	"Y"
REFERENCES_PRIV	VARCHAR2(1)	NULL
CREATED	VARCHAR2(0)	NULL

Table B-19 DBA_CATALOG

Name	Null?	Type	Value
OWNER		VARCHAR2(8)
TABLE_NAME		VARCHAR2(18)
TABLE_TYPE		VARCHAR2(7)	"TABLE" or "VIEW"or "SYNONYM"

Table B-20 DBA_CATALOG

Name	Null?	Type
OWNER		CHAR(8)
TABLE_NAME		CHAR(18)
COLUMN_NAME		CHAR(18)
COMMENTS	NOT NULL	CHAR(1)

Table B-21 DBA_OBJECTS

Name	Type	Value
OWNER	VARCHAR2(8)
OBJECT_NAME	VARCHAR2(18)
SUBOBJECT_NAME	VARCHAR2(1)	NULL
OBJECT_ID	NUMBER
DATA_OBJECT_ID	NUMBER	0
OBJECT_TYPE	VARCHAR2(9)	"TABLE" or "VIEW" or "SYNONYM" or "INDEX" or "PROCEDURE"
CREATED	DATE
LAST_DDL_TIME	VARCHAR2(0)	NULL
TIMESTAMP	VARCHAR2(1)	NULL
STATUS	VARCHAR2(5)	NULL
TEMPORARY	VARCHAR2(1)	NULL
GENERATED	VARCHAR2(1)	NULL
SECONDARY	VARCHAR2(1)	NULL

Table B-22 DBA_TAB_COLUMNS

Name	Type	Value
OWNER	VARCHAR2(8)
TABLE_NAME	VARCHAR2(18)
COLUMN_NAME	VARCHAR2(18)
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	VARCHAR2(1)	"Y" or "N"
COLUMN_ID	NUMBER(5)
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	VARCHAR2(0)	NULL
SAMPLE_SIZE	NUMBER	0
CHARACTER_SET_NAME	VARCHAR2(1)	NULL
CHAR_COL_DEC_LENGTH	NUMBER	0
GLOBAL_STATS	VARCHAR2(1)	NULL
USER_STATS	VARCHAR2(1)	NULL
AVG_COL_LEN	NUMBER	0

Table B-23 DBA_TAB_COMMENTS

Name	Type	Value
OWNER	VARCHAR2(8)
TABLE_NAME	VARCHAR2(18)
TABLE_TYPEl	VARCHAR2(5)	"TABLE" or "VIEW"
COMMENTS	VARCHAR2(1)	NULL

Table B-24 DBA_TABLES

Name	Type	Value
OWNER	VARCHAR2(8)
TABLE_NAME	VARCHAR2(18)
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(10)
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	VARCHAR2(0)	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 B-25 DICT_COLUMNS

Name	Null?	Type
TABLE_NAME		VARCHAR2(18)
COLUMN_NAME		VARCHAR2(18)
COMMENTS	NOT NULL	CHAR2(1)

Table B-26 DICTIONARY

Name	Null?	Type	Value
TABLE_NAME		VARCHAR2(18)
COMMENTS	NOT NULL	CHAR(1)

Table B-27 DUAL

Name	Null?	Type	Value
DUMMY		CHAR(1)	"X"

Table B-28 TABLE_PRIVILEGES

Name	Type	Value
GRANTEE	VARCHAR2(8)
OWNER	VARCHAR2(8)
TABLE_NAME	VARCHAR2(18)
GRANTOR	VARCHAR2(8)
SELECT_PRIV	VARCHAR2(1)	"Y" or "N"
INSERT_PRIV	VARCHAR2(1)	"Y" or "N"
DELETE_PRIV	VARCHAR2(1)	"Y" or "N"
UPDATE_PRIV	VARCHAR2(1)	"Y" or "N"
REFERENCES_PRIV	VARCHAR2(1)	"Y" or "N"
ALTER_PRIV	VARCHAR2(1)	"Y" or "N"
INDEX_PRIV	VARCHAR2(1)	"Y" or "N"
CREATED	VARCHAR2(0)	NULL

Table B-29 USER_CATALOG

Name	Null?	Type	Value
TABLE_NAME		VARCHAR2(18)
TABLE_TYPE		VARCHAR2(7)	"TABLE" or "VIEW" or "SYNONYM"

Table B-30 USER_COL_COMMENTS

Name	Type	Value
TABLE_NAME	VARCHAR2(18)
COLUMN_NAME	VARCHAR2(18)
COMMENTS	VARCHAR2(1)	NULL

Table B-31 USER_COL_PRIVS

Name	Type	Value
GRANTOR	VARCHAR2 (8)
OWNER	VARCHAR2(8)
TABLE_NAME	VARCHAR2(18)
COLUMN_NAME	VARCHAR2(18)
GRANTEE	VARCHAR2(8)
PRIVILEGE	VARCHAR2(10)	"SELECT" or "UPDATE" or "REFERENCES"
GRANTABLE	VARCHAR2(3)	"YES" or "NO"

Table B-32 USER_CONS_COLUMNS

Name	Type	Value
OWNER	VARCHAR2(8)
CONSTRAINT_NAME	VARCHAR2(18)
TABLE_NAME	VARCHAR2(18)
COLUMN_NAME	VARCHAR2(18)
POSITION	NUMBER	0

Table B-33 USER_CONSTRAINTS

Name	Type	Value
OWNER	VARCHAR2(8)
CONSTRAINT_NAME	VARCHAR2(18)
CONSTRAINT_TYPE	VARCHAR2(1)	"R" or "P" or "U" or "C"
TABLE_NAME	VARCHAR2(18)
SEARCH_CONDITION	VARCHAR2(1)	NULL
R_OWNER	VARCHAR2(18)	NULL
R_CONSTRAINT_NAME	VARCHAR2(18)	NULL
DELETE_RULE	VARCHAR2(1)	NULL
STATUS	VARCHAR2(1)	NULL
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

Table B-34 USER_IND_COLUMNS

Name	Type	Value
INDEX_NAME	VARCHAR2(18)
TABLE_NAME	VARCHAR2(18)
COLUMN_NAME	VARCHAR2(18)
COLUMN_POSITION	NUMBER	0
COLUMN_LENGTH	NUMBER	0
DESCEND	VARCHAR2(1)

Table B-35 USER_INDEXES

Name	Type	Value
INDEX_NAME	VARCHAR2(18)
INDEX_TYPE	VARCHAR2(1)	NULL
TABLE_OWNER	VARCHAR2(8)
TABLE_NAME	VARCHAR2(18)
TABLE_TYPE	VARCHAR2(5)	"TABLE"
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
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	VARCHAR2(0)	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 B-36 USER_OBJECTS

Name	Type	Value
OBJECT_NAME	VARCHAR2(18)
SUBOBJECT_NAME	VARCHAR2(1)	NULL
OBJECT_ID	NUMBER
DATA_OBJECT_ID	NUMBER	0
OBJECT_TYPE	VARCHAR2(9)	"TABLE" or "VIEW" or "SYNONYM" or "INDEX" or "PROCEDURE"
CREATED	DATE
LAST_DDL_TIME	VARCHAR2(0)
TIMESTAMP	VARCHAR2(1)	NULL
STATUS	VARCHAR2(1)	NULL
TEMPORARY	VARCHAR2(1)	NULL
GENERATED	VARCHAR2(1)	NULL
SECONDARY	VARCHAR2(1)	NULL

Table B-37 USER_SYNONYMS

Name	Type	Value
SYNONYM_NAME	VARCHAR2(18)
TABLE_OWNER`	VARCHAR2(8)
TABLE_NAME	VARCHAR2(18)
DB_LINK	VARCHAR2(1)	NULL

Table B-38 USER_TAB_COLUMNS

Name	Type	Value
TABLE_NAME	VARCHAR2(18)
COLUMN_NAME	VARCHAR2(18)
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	VARCHAR2(1)	"Y" or "N"
COLUMN_ID	NUMBER(5)
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	VARCHAR2(0)	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 B-39 USER_TAB_COMMENTS

Name	Type	Value
TABLE_NAME	VARCHAR2(18)
TABLE_TYPE	VARCHAR2(5)	"TABLE" or "VIEW"
COMMENTS	VARCHAR2(1)	NULL

Table B-40 USER_TAB_PRIVS

Name	Type	Value
GRANTEE	VARCHAR2(8)
TABcteLE_SCHEMA	VARCHAR2(8)
TABLE_NAME	VARCHAR2(18)
GRANTOR	VARCHAR2(8)
PRIVILEGE	VARCHAR2(10)	"SELECT" or "UPDATE" or "INSERT" or "DELETE" or "INDEX" or "ALTER" or "REFERENCES"
GRANTABLE	VARCHAR2(3)	"YES"

Table B-41 USER_TABLES

Name	Null?	Type	Value
TABLE_NAME	NOT NULL	VARCHAR2(255)
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		VARCHAR2(0)	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 B-42 USER_USERS

Name	Type	Value
USERNAME	VARCHAR2(8)
USER_ID	NUMBER
ACCOUNT_STATUS	VARCHAR2(4)	"OPEN"
LOCK_DATE	VARCHAR2(0)	NULL
EXPIRY_DATE	VARCHAR2(0)	NULL
DEFAULT_TABLESPACE	VARCHAR2(1)	NULL
TEMPORARY_TABLESPACE	VARCHAR2(1)	NULL
CREATED	VARCHAR2(0)	NULL
INITIAL_RSRC_CONSUMER_GROUP	VARCHAR2(1)	NULL
EXTERNAL_NAME	VARCHAR2(1)	NULL

Table B-43 USER_VIEWS

Name	Type	Value
VIEW_NAME	VARCHAR2(18)
TEXT_LENGTH	NUMBER	64
TEXT	VARCHAR2(64)
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

BData Dictionary