D
Data Dictionary Translation Support

Data dictionary information is stored in the non-Oracle system as system tables and is accessed through ODBC or OLE DB application programming interfaces (APIs). This appendix documents data dictionary translation support. It explains how to access non-Oracle data dictionaries, lists Heterogeneous Services data dictionary views, 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

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 Oracle9i 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 or OLE DB agent:

Maps the requested table, view, or synonym to one or more ODBC or OLE DB 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 Oracle8i data dictionary table.
Passes the data dictionary information from the non-Oracle system table to the Oracle8i.

Note:
The values returned when querying the generic connectivity data dictionary may not be the same as the ones returned by the Oracle Enterprise Manager DESCRIBE command.

Heterogeneous Services Data Dictionary Views

Heterogeneous Services mapping supports the following list of data dictionary views:

ALL_CATALOG
ALL_COL_COMMENTS
ALL_COL_PRIVS
ALL_COL_PRIVS_MADE
ALL_COL_PRIVS_RECD
ALL_CONSTRAINTS
ALL_CONS_COLUMNS
ALL_DB_LINKS
ALL_DEF_AUDIT_OPTS
ALL_DEPENDENCIES
ALL_ERRORS
ALL_INDEXES
ALL_IND_COLUMNS
ALL_OBJECTS
ALL_SEQUENCES
ALL_SNAPSHOTS
ALL_SOURCE
ALL_SYNONYMS
ALL_TABLES
ALL_TAB_COLUMNS
ALL_TAB_COMMENTS
ALL_TAB_PRIVS
ALL_TAB_PRIVS_MADE
ALL_TAB_PRIVS_RECD
ALL_TRIGGERS
ALL_USERS
ALL_VIEWS
AUDIT_ACTIONS
COLUMN_PRIVILEGES
DBA_CATALOG
DBA_COL_COMMENTS
DBA_COL_PRIVS
DBA_OBJECTS
DBA_ROLES
DBA_ROLE_PRIVS
DBA_SYS_PRIVS
DBA_TABLES
DBA_TAB_COLUMNS
DBA_TAB_COMMENTS
DBA_TAB_PRIVS
DBA_USERS
DICTIONARY
DICT_COLUMNS
DUAL
INDEX_STATS
PRODUCT_USER_PROFILE
RESOURCE_COST
ROLE_ROLE_PRIVS
ROLE_SYS_PRIVS
ROLE_TAB_PRIVS
SESSION_PRIVS
SESSION_ROLES
TABLE_PRIVILEGES
USER_AUDIT_OBJECT
USER_AUDIT_SESSION
USER_AUDIT_STATEMENT
USER_AUDIT_TRAIL
USER_CATALOG
USER_CLUSTERS
USER_CLU_COLUMNS
USER_COL_COMMENTS
USER_COL_PRIVS
USER_COL_PRIVS_MADE
USER_COL_PRIVS_RECD
USER_CONSTRAINTS
USER_CONS_COLUMNS
USER_DB_LINKS
USER_DEPENDENCIES
USER_ERRORS
USER_EXTENTS
USER_FREE_SPACE
USER_INDEXES
USER_IND_COLUMNS
USER_OBJECTS
USER_OBJ_AUDIT_OPTS
USER_RESOURCE_LIMITS
USER_ROLE_PRIVS
USER_SEGMENTS
USER_SEQUENCES
USER_SNAPSHOT_LOGS
USER_SOURCE
USER_SYNONYMS
USER_SYS_PRIVS
USER_TABLES
USER_TABLESPACES
USER_TAB_COLUMNS
USER_TAB_COMMENTS
USER_TAB_PRIVS
USER_TAB_PRIVS_MADE
USER_TAB_PRIVS_RECD
USER_TRIGGERS
USER_TS_QUOTAS
USER_USERS
USER_VIEWS

Supported Views and Tables

Generic connectivity supports only these views and tables:

If you use an unsupported view, then you receive the Oracle8i message for no rows 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 generic connectivity, 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 or OLE DB APIs used.

Table 7-6 Generic Connectivity Data Dictionary Mapping

View	ODBC API	OLE DB API
ALL_CATALOG	`SQLTables`	`DBSCHEMA_CATALOGS`
ALL_COL_COMMENTS	`SQLColumns`	`DBSCHEMA_COLUMNS`
ALL_CONS_COLUMNS	`SQLPrimaryKeys, SQLForeignKeys`	`DBSCHEMA_PRIMARY_KEYS, DBSCHEMA_FOREIGN_KEYS`
ALL_CONSTRAINTS	`SQLPrimaryKeys, SQLForeignKeys`	`DBSCHEMA_PRIMARY_KEYS, DBSCHEMA_FOREIGN_KEYS`
ALL_IND_COLUMNS	`SQLStatistics`	`DBSCHEMA_STATISTICS`
ALL_INDEXES	`SQLStatistics`	`DBSCHEMA_STATISTICS`
ALL_OBJECTS	`SQLTables, SQLProcedures, SQLStatistics`	`DBSCHEMA_TABLES, DBSCHEMA_PROCEDURES, DBSCHEMA_STATISTICS`
ALL_TAB_COLUMNS	`SQLColumns`	`DBSCHEMA_COLUMNS`
ALL_TAB_COMMENTS	`SQLTables`	`DBSCHEMA_TABLES`
ALL_TABLES	`SQLStatistics`	`DBSCHEMA_STATISTICS`
ALL_USERS	`SQLTables`	`DBSCHEMA_TABLES`
ALL_VIEWS	`SQLTables`	`DBSCHEMA_TABLES`
DICTIONARY	`SQLTables`	`DBSCHEMA_TABLES`
USER_CATALOG	`SQLTables`	`DBSCHEMA_TABLES`
USER_COL_COMMENTS	`SQLColumns`	`DBSCHEMA_COLUMNS`
USER_CONS_COLUMNS	`SQLPrimaryKeys, SQLForeignKeys`	`DBSCHEMA_PRIMARY_KEYS, DBSCHEMA_FOREIGN_KEYS`
USER_CONSTRAINTS	`SQLPrimaryKeys, SQLForeignKeys`	`DBSCHEMA_PRIMARY_KEYS, DBSCHEMA_FOREIGN_KEYS`
USER_IND_COLUMNS	`SQLStatistics`	`DBSCHEMA_STATISTICS`
USER_INDEXES	`SQLStatistics`	`DBSCHEMA_STATISTICS`
USER_OBJECTS	`SQLTables, SQLProcedures, SQLStatistics`	`DBSCHEMA_TABLES, DBSCHEMA_PROCEDURES, DBSCHEMA_STATISTICS`
USER_TAB_COLUMNS	`SQLColumns`	`DBSCHEMA_COLUMNS`
USER_TAB_COMMENTS	`SQLTables`	`DBSCHEMA_TABLES`
USER_TABLES	`SQLStatistics`	`DBSCHEMA_STATISTICS`
USER_USERS	`SQLTables`	`DBSCHEMA_TABLES`
USER_VIEWS	`SQLTables`	`DBSCHEMA_TABLES`

Generic Connectivity Data Dictionary Descriptions

The generic connectivity data dictionary tables and views provide this 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 Oracle9i data dictionary tables and views. Any default value is shown to the right of an item.

`ALL_CATALOG`

Name	Null?	Type	Value
`OWNER`	`NOT NULL`	`VARCHAR2(30)`
`TABLE_NAME`	`NOT NULL`	`VARCHAR2(30)`
`TABLE_TYPE`		`VARCHAR2(11)`	`"TABLE"` or "`VIEW"` or `SYNONYM`

`ALL_COL_COMMENTS`

Name	Null?	Type	Value
`OWNER`	`NOT NULL`	`VARCHAR2(30)`
`TABLE_NAME`	`NOT NULL`	`VARCHAR2(30)`
`COLUMN_NAME`	`NOT NULL`	`VARCHAR2(30)`
`COMMENTS`		`VARCHAR2(4000)`	`NULL`

`ALL_CONS_COLUMNS`

Name	Null?	Type
`OWNER`	`NOT NULL`	`VARCHAR2(30)`
`CONSTRAINT_NAME`	`NOT NULL`	`VARCHAR2(30)`
`TABLE_NAME`	`NOT NULL`	`VARCHAR2(30)`
`COLUMN_NAME`		`VARCHAR2(4000)`
`POSITION`		`NUMBER`

`ALL_CONSTRAINTS`

Name	Null?	Type	Value
`OWNER`	`NOT NULL`	`VARCHAR2(30)`
`CONSTRAINT_NAME`	`NOT NULL`	`VARCHAR2(30)`
`CONSTRAINT_TYPE`		`VARCHAR2(1)`	`"R"` or "`P"`
`TABLE_NAME`	`NOT NULL`	`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`

`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`	`NUMBER`
`COLUMN_LENGTH`	`NOT NULL`	`NUMBER`
`DESCEND`		`VARCHAR2(4)`	`"DESC"` or "`ASC"`

`ALL_INDEXES`

Name	Null?	Type	Value
`OWNER`	`NOT NULL`	`VARCHAR2(30)`
`INDEX_NAME`	`NOT NULL`	`VARCHAR2(30)`
`INDEX_TYPE`		`VARCHAR2(27)`	`NULL`
`TABLE_OWNER`	`NOT NULL`	`VARCHAR2(30)`
`TABLE_NAME`	`NOT NULL`	`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`

`ALL_OBJECTS`

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

`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`	`NOT NULL`	`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`

`ALL_TAB_COMMENTS`

Name	Null?	Type	Value
`OWNER`	`NOT NULL`	`VARCHAR2(30)`
`TABLE_NAME`	`NOT NULL`	`VARCHAR2(30)`
`TABLE_TYPE`		`VARCHAR2(11)`	`"TABLE"` or "`VIEW"`
`COMMENTS`		`VARCHAR2(4000)`	`NULL`

`ALL_TABLES`

Name	Null?	Type	Value
`OWNER`	`NOT NULL`	`VARCHAR2(30)`
`TABLE_NAME`	`NOT NULL`	`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`		`VARHCAR2(15)`	`NULL`
`SKIP_CORRUPT`		`VARCHAR2(8)`	`NULL`
`MONITORING`		`VARCHAR2(3)`	`NULL`

`ALL_USERS`

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

`ALL_VIEWS`

Name	Null?	Type	Value
`OWNER`	`NOT NULL`	`VARCHAR2(30)`
`VIEW_NAME`	`NOT NULL`	`VARCHAR2(30)`
`TEXT_LENGTH`		`NUMBER`	`0`
`TEXT`	`NOT NULL`	`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`

`DICTIONARY`

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

`USER_CATALOG`

Name	Null?	Type	Value
`TABLE_NAME`	`NOT NULL`	`VARCHAR2(30)`
`TABLE_TYPE`		`VARCHAR2(11)`	`"TABLE"` or, `"VIEW"` or `"SYNONYM"`

`USER_COL_COMMENTS`

Name	Null?	Type	Value
`TABLE_NAME`	`NOT NULL`	`VARCHAR2(30)`
`COLUMN_NAME`	`NOT NULL`	`VARCHAR2(30)`
`COMMENTS`		`VARCHAR2(4000)`	`NULL`

`USER_CONS_COLUMNS`

Name	Null?	Type
`OWNER`	`NOT NULL`	`VARCHAR2(30)`
`CONSTRAINT_NAME`	`NOT NULL`	`VARCHAR2(30)`
`TABLE_NAME`	`NOT NULL`	`VARCHAR2(30)`
`COLUMN_NAME`		`VARCHAR2(4000)`
`POSITION`		`NUMBER`

`USER_CONSTRAINTS`

Name	Null?	Type	Value
`OWNER`	`NOT NULL`	`VARCHAR2(30)`
`CONSTRAINT_NAME`	`NOT NULL`	`VARCHAR2(30)`
`CONSTRAINT_TYPE`		`VARCHAR2(1)`	`R` or `P`
`TABLE_NAME`	`NOT NULL`	`VARCHAR2(30)`
`SEARCH_CONDITION`		`LONG`	`NULL`
`R_OWNER`		`VARCHAR2(30)`
`R_CONSTRAINT_NAME`		`VARCHAR2(30)`
`DELETE_RULE`		`VARCHAR2(9)`	`"CASCADE"` or `"NOACTION`" 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`

`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"`

`USER_INDEXES`

Name	Null?	Type	Value
`INDEX_NAME`	`NOT NULL`	`VARCHAR2(30)`
`INDEX_TYPE`		`VARCHAR2(27)`	`NULL`
`TABLE_OWNER`	`NOT NULL`	`VARCHAR2(30)`
`TABLE_NAME`	`NOT NULL`	`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`

`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`

`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`		`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`	`NOT NULL`	`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`

`USER_TAB_COMMENTS`

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

`USER_TABLES`

Name	Null?	Type	Value
`TABLE_NAME`	`NOT NULL`	`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`

`USER_USERS`

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

`USER_VIEWS`

Name	Null?	Type	Value
`VIEW_NAME`	`NOT NULL`	`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`

D Data Dictionary Translation Support

Accessing the Non-Oracle Data Dictionary

Heterogeneous Services Data Dictionary Views

Supported Views and Tables

Data Dictionary Mapping

Table 7-6 Generic Connectivity Data Dictionary Mapping

Generic Connectivity Data Dictionary Descriptions

ALL_CATALOG

ALL_COL_COMMENTS

ALL_CONS_COLUMNS

ALL_CONSTRAINTS

ALL_IND_COLUMNS

ALL_INDEXES

ALL_OBJECTS

ALL_TAB_COLUMNS

ALL_TAB_COMMENTS

ALL_TABLES

ALL_USERS

ALL_VIEWS

DICTIONARY

USER_CATALOG

USER_COL_COMMENTS

USER_CONS_COLUMNS

USER_CONSTRAINTS

USER_IND_COLUMNS

USER_INDEXES

USER_OBJECTS

USER_TAB_COLUMNS

USER_TAB_COMMENTS

USER_TABLES

USER_USERS

USER_VIEWS