Skip Headers
Oracle® Database Gateway for ODBC User's Guide
11g Release 1 (11.1)

Part Number E10311-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

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:

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

  1. Maps the requested table, view, or synonym to one or more ODBC APIs (see Section C.2.1, "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 Oracle data dictionary table.

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

C.2 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.

C.2.1 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

USER_CATALOG


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_TAB_COLUMNS


SQLColumns

USER_TAB_COMMENTS


SQLTables

USER_TABLES


SQLStatistics

USER_USERS


SQLTables

USER_VIEWS


SQLTables


C.2.2 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.

C.2.2.1 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"

C.2.2.2 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

C.2.2.3 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 -

C.2.2.4 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

C.2.2.5 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"

C.2.2.6 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

C.2.2.7 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

C.2.2.8 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

C.2.2.9 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

C.2.2.10 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 - 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

C.2.2.11 ALL_USERS

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

C.2.2.12 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

C.2.2.13 DICTIONARY

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

C.2.2.14 DICT_COLUMNS

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

C.2.2.15 USER_CATALOG

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

C.2.2.16 USER_COL_COMMENTS

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

C.2.2.17 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 -

C.2.2.18 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 "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

C.2.2.19 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"

C.2.2.20 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

C.2.2.21 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

C.2.2.22 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

C.2.2.23 USER_TAB_COMMENTS

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

C.2.2.24 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

C.2.2.25 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

C.2.2.26 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