C Data Dictionary

Data dictionary information is stored in the non-Oracle system as system tables and is accessed through ODBC application programming interfaces (APIs). This appendix documents data dictionary translation support. It explains how to access non-Oracle data dictionaries, describes how to use supported views and tables, and explains data dictionary mapping.

This appendix contains the following topics:

Accessing the Non-Oracle Data Dictionary
Views and Tables Supported by Oracle Database Gateway for ODBC

Accessing the Non-Oracle Data Dictionary

Accessing a non-Oracle data dictionary table or view is identical to accessing a data dictionary in an Oracle database. You issue a SELECT statement specifying a database link. The Oracle data dictionary view and column names are used to access the non-Oracle data dictionary. Synonyms of supported views are also acceptable.

For example, the following statement queries the data dictionary table ALL_USERS to retrieve all users in the non-Oracle system:

SQL SELECT * FROM all_users@sid1;

When you issue a data dictionary access query, the ODBC agent:

Maps the requested table, view, or synonym to one or more ODBC APIs (see Data Dictionary Mapping). The agent translates all data dictionary column names to their corresponding non-Oracle column names within the query.
Sends the sequence of APIs to the non-Oracle system.
Possibly converts the retrieved non-Oracle data to give it the appearance of the Oracle data dictionary table.
Passes the data dictionary information from the non-Oracle system table to Oracle.

Note:
The values returned when querying the Oracle Database Gateway for ODBC data dictionary may not be the same as those returned by the Oracle SQL*Plus DESCRIBE command.

Views and Tables Supported by Oracle Database Gateway for ODBC

Oracle Database Gateway for ODBC supports only the views and tables shown in Table C-1.

If you use an unsupported view, you receive an Oracle error message stating no rows were selected.

If you want to query 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

Using Oracle Database Gateway for ODBC, queries of the supported data dictionary tables and views beginning with the characters ALL_ may return rows from the non-Oracle system when you do not have access privileges for those non-Oracle 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 ODBC APIs used. Table C-1 shows a list of all Oracle data dictionary view names supported by Oracle Database Gateway for ODBC.

Table C-1 Oracle Database Gateway for ODBC Data Dictionary Mapping

View	ODBC API
ALL_CATALOG	`SQLTables`
ALL_COL_COMMENTS	`SQLColumns`
ALL_CONS_COLUMNS	`SQLPrimaryKeys, SQLForeignKeys`
ALL_CONSTRAINTS	`SQLPrimaryKeys, SQLForeignKeys`
ALL_IND_COLUMNS	`SQLStatistics`
ALL_INDEXES	`SQLStatistics`
ALL_OBJECTS	`SQLTables, SQLProcedures, SQLStatistics`
ALL_TAB_COLUMNS	`SQLColumns`
ALL_TAB_COMMENTS	`SQLTables`
ALL_TABLES	`SQLStatistics`
ALL_USERS	`SQLTables`
ALL_VIEWS	`SQLTables`
DICTIONARY	`SQLTables`
DICT_COLUMNS	`SQLTables`
USER_COL_COMMENTS	`SQLColumns`
USER_CONS_COLUMNS	`SQLPrimaryKeys, SQLForeignKeys`
USER_CONSTRAINTS	`SQLPrimaryKeys, SQLForeignKeys`
USER_IND_COLUMNS	`SQLStatistics`
USER_INDEXES	`SQLStatistics`
USER_OBJECTS	`SQLTables, SQLProcedures, SQLStatistics`
USER_TABCOLUMNS	`SQLColumns`
USER_TAB_COMMENTS	`SQLTables`
USER_TABLES	`SQLStatistics`
USER_USERS	`SQLTables`
USER_VIEWS	`SQLTables`

Oracle Database Gateway for ODBC Data Dictionary Descriptions

The Oracle Database Gateway for ODBC data dictionary tables and views provide the following information:

Name, data type, 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 data dictionary tables and views. Any default value is shown to the right of an item.

Table C-2 ALL_CATALOG

Name	Type	Value
`OWNER`	`VARCHAR2(30)`	-
`TABLE_NAME`	`VARCHAR2(30)`	-
`TABLE_TYPE`	`VARCHAR2(11)`	`"TABLE"` or "`VIEW"` or `"SYNONYM"`

Table C-3 ALL_COL_COMMENTS

Name	Type	Value
`OWNER`	`VARCHAR2(30)`	-
`TABLE_NAME`	`VARCHAR2(30)`	-
`COLUMN_NAME`	`VARCHAR2(30)`	-
`COMMENTS`	`VARCHAR2(4000)`	`NULL`

Table C-4 ALL_CONS_COLUMNS

Name	Type	Value
`OWNER`	`VARCHAR2(30)`	-
`CONSTRAINT_NAME`	`VARCHAR2(30)`	-
`TABLE_NAME`	`VARCHAR2(30)`	-
`COLUMN_NAME`	`VARCHAR2(4000)`	-
`POSITION`	`NUMBER`	-

Table C-5 ALL_CONSTRAINTS

Name	Type	Value
`OWNER`	`VARCHAR2(30)`	-
`CONSTRAINT_NAME`	`VARCHAR2(30)`	-
`CONSTRAINT_TYPE`	`VARCHAR2(1)`	`"R"` or "`P"`
`TABLE_NAME`	`VARCHAR2(30)`	-
`SEARCH_CONDITION`	`LONG`	`NULL`
`R_OWNER`	`VARCHAR2(30)`	-
`R_CONSTRAINT_NAME`	`VARCHAR2(30)`	-
`DELETE_RULE`	`VARCHAR2(9)`	`"CASCADE"` or `"NO ACTION"` or `"SET NULL"`
`STATUS`	`VARCHAR2(8)`	`NULL`
`DEFERRABLE`	`VARCHAR2(14)`	`NULL`
`DEFERRED`	`VARCHAR2(9)`	`NULL`
`VALIDATED`	`VARCHAR2(13)`	`NULL`
`GENERATED`	`VARCHAR2(14)`	`NULL`
`BAD`	`VARCHAR2(3)`	`NULL`
`RELY`	`VARCHAR2(4)`	`NULL`
`LAST_CHANGE`	`DATE`	`NULL`

Table C-6 ALL_IND_COLUMNS

Name	Type	Value
`INDEX_OWNER`	`VARCHAR2(30)`	-
`INDEX_NAME`	`VARCHAR2(30)`	-
`TABLE_OWNER`	`VARCHAR2(30)`	-
`TABLE_NAME`	`VARCHAR2(30)`	-
`COLUMN_NAME`	`VARCHAR2(4000)`	-
`COLUMN_POSITION`	`NUMBER`	-
`COLUMN_LENGTH`	`NUMBER`	-
`DESCEND`	`VARCHAR2(4)`	`"DESC"` or "`ASC"`

Table C-7 ALL_INDEXES

Name	Type	Value
`OWNER`	`VARCHAR2(30)`	-
`INDEX_NAME`	`VARCHAR2(30)`	-
`INDEX_TYPE`	`VARCHAR2(27)`	`NULL`
`TABLE_OWNER`	`VARCHAR2(30)`	-
`TABLE_NAME`	`VARCHAR2(30)`	-
`TABLE_TYPE`	`CHAR(5)`	`"TABLE"`
`UNIQUENESS`	`VARCHAR2(9)`	`"UNIQUE"` or `"NONUNIQUE"`
`COMPRESSION`	`VARCHAR2(8)`	`NULL`
`PREFIX_LENGTH`	`NUMBER`	`0`
`TABLESPACE_NAME`	`VARCHAR2(30)`	`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_COLUMNS`	`NUMBER`	`0`
`FREELISTS`	`NUMBER`	`0`
`FREELIST_GROUPS`	`NUMBER`	`0`
`PCT_FREE`	`NUMBER`	`0`
`LOGGING`	`VARCHAR2(3)`	`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(8)`	`NULL`
`NUM_ROWS`	`NUMBER`	`0`
`SAMPLE_SIZE`	`NUMBER`	`0`
`LAST_ANALYZED`	`DATE`	`NULL`
`DEGREE`	`VARCHAR2(40)`	`NULL`
`INSTANCES`	`VARCHAR2(40)`	`NULL`
`PARTITIONED`	`VARCHAR2(3)`	`NULL`
`TEMPORARY`	`VARCHAR2(1)`	`NULL`
`GENERATED`	`VARCHAR2(1)`	`NULL`
`SECONDARY`	`VARCHAR2(1)`	`NULL`
`BUFFER_POOL`	`VARCHAR2(7)`	`NULL`
`USER_STATS`	`VARCHAR2(3)`	`NULL`
`DURATION`	`VARCHAR2(15)`	`NULL`
`PCT_DIRECT_ACCESS`	`NUMBER`	`0`
`ITYP_OWNER`	`VARCHAR2(30)`	`NULL`
`ITYP_NAME`	`VARCHAR2(30)`	`NULL`
`PARAMETERS`	`VARCHAR2(1000)`	`NULL`
`GLOBAL_STATS`	`VARCHAR2(3)`	`NULL`
`DOMIDX_STATUS`	`VARCHAR2(12)`	`NULL`
`DOMIDX_OPSTATUS`	`VARCHAR2(6)`	`NULL`
`FUNCIDX_STATUS`	`VARCHAR2(8)`	`NULL`

Table C-8 ALL_OBJECTS

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

Table C-9 ALL_TAB_COLUMNS

Name	Type	Value
`OWNER`	`VARCHAR2(30)`	-
`TABLE_NAME`	`VARCHAR2(30)`	-
`COLUMN_NAME`	`VARCHAR2(30)`	-
`DATA_TYPE`	`VARCHAR2(106)`	-
`DATA_TYPE_MOD`	`VARCHAR2(3)`	`NULL`
`DATA_TYPE_OWNER`	`VARCHAR2(30)`	`NULL`
`DATA_LENGTH`	`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)`	`NULL`
`HIGH_VALUE`	`RAW(32)`	`NULL`
`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_DEC_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	Type	Value
`OWNER`	`VARCHAR2(30)`	-
`TABLE_NAME`	`VARCHAR2(30)`	-
`TABLE_TYPE`	`VARCHAR2(11)`	`"TABLE"` or "`VIEW"`
`COMMENTS`	`VARCHAR2(4000)`	`NULL`

Table C-11 ALL_TABLES

Name	Type	Value
`OWNER`	`VARCHAR2(30)`	-
`TABLE_NAME`	`VARCHAR2(30)`	-
`TABLESPACE_NAME`	`VARCHAR2(30)`	`NULL`
`CLUSTER_NAME`	`VARCHAR2(30)`	`NULL`
`IOT_NAME`	`VARCHAR2(30)`	`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(3)`	`NULL`
`BACKED_UP`	`VARCHAR2(1)`	`NULL`
`NUM_ROWS`	`NUMBER`	-
`BLOCKS`	`NUMBER`	-
`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(10)`	`NULL`
`INSTANCES`	`VARCHAR2(10)`	`NULL`
`CACHE`	`VARCHAR2(5)`	`NULL`
`TABLE_LOCK`	`VARCHAR2(8)`	`NULL`
`SAMPLE_SIZE`	`NUMBER`	`0`
`LAST_ANALYZED`	`DATE`	`NULL`
`PARTITIONED`	`VARCHAR2(3)`	`NULL`
`IOT_TYPE`	`VARCHAR2(12)`	`NULL`
`TEMPORARY`	`VARCHAR2(1)`	`NULL`
`SECONDARY`	`VARCHAR2(1)`	`NULL`
`NESTED`	`VARCHAR2(3)`	`NULL`
`BUFFER_POOL`	`VARCHAR2(7)`	`NULL`
`ROW_MOVEMENT`	`VARCHAR2(8)`	`NULL`
`GLOBAL_STATS`	`VARCHAR2(3)`	`NULL`
`USER_STATS`	`VARCHAR2(3)`	`NULL`
`DURATION`	`VARHCAR2(15)`	`NULL`
`SKIP_CORRUPT`	`VARCHAR2(8)`	`NULL`
`MONITORING`	`VARCHAR2(3)`	`NULL`

Table C-12 ALL_USERS

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

Table C-13 ALL_VIEWS

Name	Type	Value
`OWNER`	`VARCHAR2(30)`	-
`VIEW_NAME`	`VARCHAR2(30)`	-
`TEXT_LENGTH`	`NUMBER`	`0`
`TEXT`	`LONG`	`NULL`
`TYPE_TEXT_LENGTH`	`NUMBER`	`0`
`TYPE_TEXT`	`VARCHAR2(4000)`	`NULL`
`OID_TEXT_LENGTH`	`NUMBER`	`0`
`OID_TEXT`	`VARCHAR2(4000)`	`NULL`
`VIEW_TYPE_OWNER`	`VARCHAR2(30)`	`NULL`
`VIEW_TYPE`	`VARCHAR2(30)`	`NULL`

Table C-14 DICTIONARY

Name	Type	Value
`TABLE_NAME`	`VARCHAR2(30)`	-
`COMMENTS`	`VARCHAR2(4000)`	`NULL`

Table C-15 DICT_COLUMNS

Name	Type	Value
`TABLE_NAME`	`VARCHAR2(30)`	-
`COLUMN_NAME`	`VARCHAR2(30)`	-
`COMMENTS`	`VARCHAR2(4000)`	`NULL`

Table C-16 USER_CATALOG

Name	Type	Value
`TABLE_NAME`	`VARCHAR2(30)`	-
`TABLE_TYPE`	`VARCHAR2(11)`	`"TABLE"` or, `"VIEW"` or `"SYNONYM"`

Table C-17 USER_COL_COMMENTS

Name	Type	Value
`TABLE_NAME`	`VARCHAR2(30)`	-
`COLUMN_NAME`	`VARCHAR2(30)`	-
`COMMENTS`	`VARCHAR2(4000)`	`NULL`

Table C-18 USER_CONS_COLUMNS

Name	Type	Value
`OWNER`	`VARCHAR2(30)`	-
`CONSTRAINT_NAME`	`VARCHAR2(30)`	-
`TABLE_NAME`	`VARCHAR2(30)`	-
`COLUMN_NAME`	`VARCHAR2(4000)`	-
`POSITION`	`NUMBER`	-

Table C-19 USER_CONSTRAINTS

Name	Type	Value
`OWNER`	`VARCHAR2(30)`	-
`CONSTRAINT_NAME`	`VARCHAR2(30)`	-
`CONSTRAINT_TYPE`	`VARCHAR2(1)`	`R` or `P`
`TABLE_NAME`	`VARCHAR2(30)`	-
`SEARCH_CONDITION`	`LONG`	`NULL`
`R_OWNER`	`VARCHAR2(30)`	-
`R_CONSTRAINT_NAME`	`VARCHAR2(30)`	-
`DELETE_RULE`	`VARCHAR2(9)`	`"CASCADE"` or `"NO ACTION`" or `"SET NULL"`
`STATUS`	`VARCHAR2(8)`	`NULL`
`DEFERRABLE`	`VARCHAR2(14)`	`NULL`
`DEFERRED`	`VARCHAR2(9)`	`NULL`
`VALIDATED`	`VARCHAR2(13)`	`NULL`
`GENERATED`	`VARCHAR2(14)`	`NULL`
`BAD`	`VARCHAR2(3)`	`NULL`
`RELY`	`VARCHAR2(4)`	`NULL`
`LAST_CHANGE`	`DATE`	`NULL`

Table C-20 USER_IND_COLUMNS

Name	Type	Value
`INDEX_NAME`	`VARCHAR2(30)`	-
`TABLE_NAME`	`VARCHAR2(30)`	-
`COLUMN_NAME`	`VARCHAR2(4000)`	`-`
`COLUMN_POSITION`	`NUMBER`	`-`
`COLUMN_LENGTH`	`NUMBER`	`-`
`DESCEND`	`VARCHAR2(4)`	`"DESC"` or "`ASC"`

Table C-21 USER_INDEXES

Name	Type	Value

`INDEX_NAME`	`VARCHAR2(30)`	`-`
`INDEX_TYPE`	`VARCHAR2(27)`	`NULL`
`TABLE_OWNER`	`VARCHAR2(30)`	-
`TABLE_NAME`	`VARCHAR2(30)`	-
`TABLE_TYPE`	`VARCHAR2(11)`	`"TABLE"`
`UNIQUENESS`	`VARCHAR2(9)`	`"UNIQUE"` or `"NONUNIQUE"`
`COMPRESSION`	`VARCHAR2(8)`	`NULL`
`PREFIX_LENGTH`	`NUMBER`	`0`
`TABLESPACE_NAME`	`VARCHAR2(30)`	`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_COLUMNS`	`NUMBER`	`0`
`FREELISTS`	`NUMBER`	`0`
`FREELIST_GROUPS`	`NUMBER`	`0`
`PCT_FREE`	`NUMBER`	`0`
`LOGGING`	`VARCHAR2(3)`	`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(8)`	`NULL`
`NUM_ROWS`	`NUMBER`	`0`
`SAMPLE_SIZE`	`NUMBER`	`0`
`LAST_ANALYZED`	`DATE`	`NULL`
`DEGREE`	`VARCHAR2(40)`	`NULL`
`INSTANCES`	`VARCHAR2(40)`	`NULL`
`PARTITIONED`	`VARCHAR2(3)`	`NULL`
`TEMPORARY`	`VARCHAR2(1)`	`NULL`
`GENERATED`	`VARCHAR2(1)`	`NULL`
`SECONDARY`	`VARCHAR2(1)`	`NULL`
`BUFFER_POOL`	`VARCHAR2(7)`	`NULL`
`USER_STATS`	`VARCHAR2(3)`	`NULL`
`DURATION`	`VARHCAR2(15)`	`NULL`
`PCT_DIRECT_ACCESS`	`NUMBER`	`0`
`ITYP_OWNER`	`VARCHAR2(30)`	`NULL`
`ITYP_NAME`	`VARCHAR2(30)`	`NULL`
`PARAMETERS`	`VARCHAR2(1000)`	`NULL`
`GLOBAL_STATS`	`VARCHAR2(3)`	`NULL`
`DOMIDX_STATUS`	`VARCHAR2(12)`	`NULL`
`DOMIDX_OPSTATUS`	`VARCHAR2(6)`	`NULL`
`FUNCIDX_STATUS`	`VARCHAR2(8)`	`NULL`

Table C-22 USER_OBJECTS

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

Table C-23 USER_TABCOLUMNS

Name	Type	Value
`TABLE_NAME`	`VARCHAR2(30)`	-
`COLUMN_NAME`	`VARCHAR2(30)`	-
`DATA_TYPE`	`VARCHAR2(106)`	-
`DATA_TYPE_MOD`	`VARCHAR2(3)`	`NULL`
`DATA_TYPE_OWNER`	`VARCHAR2(30)`	`NULL`
`DATA_LENGTH`	`NUMBER`	-
`DATA_PRECISION`	`NUMBER`	-
`DATA_SCALE`	`NUMBER`	-
`NULLABLE`	`VARCHAR2(1)`	`"Y"` or "`N"`
`COLUMN_ID`	`NUMBER`	-
`DEFAULT_LENGTH`	`NUMBER`	`NULL`
`DATA_DEFAULT`	`LONG`	`NULL`
`NUM_DISTINCT`	`NUMBER`	`NULL`
`LOW_VALUE`	`RAW(32)`	`NULL`
`HIGH_VALUE`	`RAW(32)`	`NULL`
`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-24 USER_TAB_COMMENTS

Name	Type	Value
`TABLE_NAME`	`VARCHAR2(30)`	-
`TABLE_TYPE`	`VARCHAR2(11)`	`"TABLE"` or `"VIEW"`
`COMMENTS`	`VARCHAR2(4000)`	`NULL`

Table C-25 USER_TABLES

Name	Type	Value
`TABLE_NAME`	`VARCHAR2(30)`	-
`TABLESPACE_NAME`	`VARCHAR2(30)`	`NULL`
`CLUSTER_NAME`	`VARCHAR2(30)`	`NULL`
`IOT_NAME`	`VARCHAR2(30)`	`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(3)`	`NULL`
`BACKED_UP`	`VARCHAR2(1)`	`NULL`
`NUM_ROWS`	`NUMBER`	-
`BLOCKS`	`NUMBER`	-
`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(10)`	`NULL`
`INSTANCES`	`VARCHAR2(10)`	`NULL`
`CACHE`	`VARCHAR2(5)`	`NULL`
`TABLE_LOCK`	`VARCHAR2(8)`	`NULL`
`SAMPLE_SIZE`	`NUMBER`	`0`
`LAST_ANALYZED`	`DATE`	`NULL`
`PARTITIONED`	`VARCHAR2(3)`	`NULL`
`IOT_TYPE`	`VARCHAR2(12)`	`NULL`
`TEMPORARY`	`VARHCAR2(1)`	`NULL`
`SECONDARY`	`VARCHAR2(1)`	`NULL`
`NESTED`	`VARCHAR2(3)`	`NULL`
`BUFFER_POOL`	`VARCHAR2(7)`	`NULL`
`ROW_MOVEMENT`	`VARCHAR2(8)`	`NULL`
`GLOBAL_STATS`	`VARCHAR2(3)`	`NULL`
`USER_STATS`	`VARCHAR2(3)`	`NULL`
`DURATION`	`VARCHAR2(15)`	`NULL`
`SKIP_CORRUPT`	`VARCHAR2(8)`	`NULL`
`MONITORING`	`VARCHAR2(3)`	`NULL`

Table C-26 USER_USERS

Name	Type	Value
`USERNAME`	`VARCHAR2(30)`	-
`USER_ID`	`NUMBER`	`0`
`ACCOUNT_STATUS`	`VARCHAR2(32)`	`OPEN`
`LOCK_DATE`	`DATE`	`NULL`
`EXPIRY_DATE`	`DATE`	`NULL`
`DEFAULT_TABLESPACE`	`VARCHAR2(30)`	`NULL`
`TEMPORARY_TABLESPACE`	`VARCHAR2(30)`	`NULL`
`CREATED`	`DATE`	`NULL`
`INITIAL_RSRC_CONSUMER_GROUP`	`VARCHAR2(30)`	`NULL`
`EXTERNAL_NAME`	`VARCHAR2(4000)`	`NULL`

Table C-27 USER_VIEWS

Name	Type	Value
`VIEW_NAME`	`VARCHAR2(30)`	-
`TEXT_LENGTH`	`NUMBER`	`0`
`TEXT`	`LONG`	`NULL`
`TYPE_TEXT_LENGTH`	`NUMBER`	`0`
`TYPE_TEXT`	`VARCHAR2(4000)`	`NULL`
`OID_TEXT_LENGTH`	`NUMBER`	`0`
`OID_TEXT`	`VARCHAR2(4000)`	`NULL`
`VIEW_TYPE_OWNER`	`VARCHAR2(30)`	`NULL`
`VIEW_TYPE`	`VARCHAR2(30)`	`NULL`