Oracle Heterogeneous Services Release 8.1.7 Part Number A88714-01 |
Library | Service | Contents | Index

# D
Data Dictionary Translation for Generic Connectivity

Generic connectivity agents translate a query that refers to an Oracle8i data dictionary table into a query that retrieves the data from a non-Oracle data dictionary. You perform queries on data dictionary tables over the database link in the same way you query data dictionary tables in Oracle8i. The generic connectivity data dictionary is similar to the Oracle8i data dictionary in appearance and use. Non-Oracle data dictionary information is supplied to the user in Oracle8i data dictionary format.

To better understand the data dictionary support provided by generic connectivity, read these sections:

- Data Dictionary Translation Support

- Data Dictionary Mapping

- Generic Connectivity Data Dictionary Descriptions

## Data Dictionary Translation Support

Data dictionary information is stored in the non-Oracle system as system tables and accessed through ODBC or OLE DB application programming interfaces (APIs). This section contains the following topics:

- Accessing the Non-Oracle Data Dictionary

- Supported Views and Tables

### 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 Oracle8i 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:

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

2. Sends the sequence of APIs to the non-Oracle system.

3. Possibly converts the retrieved non-Oracle data to give it the appearance of the Oracle8i data dictionary table.

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

### Supported Views and Tables

Generic connectivity supports only these views and tables:

- 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

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

### Default Column Values

The generic connectivity data dictionary differs from a typical Oracle database server data dictionary. The Oracle database server columns that are missing in a non-Oracle data dictionary table are filled with the following, depending on the column type:

- Zeros

- Spaces

- NULL values

- Default values

## 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 Oracle8i 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 | Value
--- | --- | --- | ---
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 | Value
--- | --- | --- | ---
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 | Null? | 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 | Null? | 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

| Copyright © 1996-2001 Oracle Corporation. All Rights Reserved. |
Library | Service | Contents | Index