Skip Headers
Oracle® Transparent Gateway for Teradata Administrator's Guide
10g Release 2 (10.2) for Solaris Operating System (SPARC)
Part Number B14280-01
Go to Documentation Home
Home		 Go to Book List
Book List		 Go to Table of Contents
Contents		 Go to Index
Index		 Go to Master Index
Master Index		 Go to Feedback page
Feedback
Go to previous page
Previous		 Go to next page
Next
View PDF

C Data Dictionary

The Oracle Transparent Gateway for Teradata Administrator's Guide translates a query that refers to an Oracle database server data dictionary table into a query that retrieves the data from Teradata system catalog tables. 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:

C.1 Data Dictionary Support

The following paragraphs describe the Oracle Transparent Gateway for Teradata data dictionary support.

C.1.1 Teradata System Catalog Tables

Teradata data dictionary information is stored in the Teradata database as Teradata system catalog tables. The Teradata system catalog tables define the structure of a database. When you change data definitions, Teradata reads and modifies the Teradata system catalog tables to add information about the user tables.

C.1.2 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. The Oracle database server data dictionary view and column names are used to access the gateway data dictionary in an Oracle database. Synonyms of supported views are also acceptable. For example, the following statement queries the data dictionary table ALL_CATALOG to retrieve all table names in the Teradata database:

SQL> SELECT * FROM "ALL_CATALOG"@TERA;

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

  1. Uses ODBC API to retrieve information from Teradata system catalog. Refere to "Data Dictionary Mapping" for details.

  2. Sends the translated query to Teradata.

  3. Might convert the retrieved Teradata data to give it the appearance of the Oracle database server data dictionary table.

  4. Passes the data dictionary information from the translated Teradata system catalog 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.

C.1.3 Direct Queries to Teradata Tables

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

C.1.4 Supported Views and Tables

The gateway supports the following views and tables:

Supported Views and Tables Supported 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
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_CONS_COLUMNS USER_CONSTRAINTS
USER_IND_COLUMNS USER_INDEXES
USER_OBJECTS USER_TAB_COLUMNS
USER_TAB_COMMENTS USER_TABLES
USER_USER 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 any data dictionary table or view beginning with ALL_ can returns rows from the Teradata database even when access privileges for those Teradata objects have not been granted. When querying an Oracle database with the Oracle data dictionary, rows are returned only for those objects you are permitted to access.

C.2 Data Dictionary Mapping

The tables in this section list Oracle data dictionary view names and ODBC API's used.

Table C-1 Oracle Data Dictionary View Names and Teradata Equivalents

View Name ODBC API Used
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
DBA_CATALOG SQLTables
DBA_COL_COMMENTS SQLColumns
DBA_OBJECTS SQLTables, SQLProcedures, SQLStatistics
DBA_TAB_COLUMNS SQLColumns
DBA_TAB_COMMENTS SQLTables
DBA_TABLES SQLStatistics
DICT_COLUMNS SQLColumns
DICTIONARY SQLTables
DUAL (Defined in the Gateway)
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.1 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 an Teradata system catalog table are filled with zeros, spaces, null values, not-applicable values (N.A.), or default values, depending on the column type.

C.3 Gateway Data Dictionary Descriptions

The gateway data dictionary tables and views provide the following information:

They are described here with information retrieved by an SQL*PLUS DESCRIBE command. The values in the Null? column might differ from the Oracle database server data dictionary tables and views. Any hardcoded default value is shown to the right of an item, but this is not information returned by DESCRIBE.

Table C-2 ALL_CATALOG

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

Table C-3 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 NOT NULL CHAR(1) " "

Table C-4 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(8192) -
POSITION - FLOAT(49) -

Table C-5  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 NOT NULL CHAR(1) " "
R_OWNER NOT NULL VARCHAR2(30) " "
R_CONSTRAINT_NAME NOT NULL VARCHAR2(30) " "
DELETE_RULE NOT NULL VARCHAR2(9) " "
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 NULL

Table C-6 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(8192) -
COLUMN_POSITION NOT NULL FLOAT(49) -
COLUMN_LENGTH NOT NULL FLOAT(49) -
DESCEND - VARCHAR2(4) "DESC" or "ASC"

Table C-7 ALL_INDEXES

Name Null? Type Value
OWNER NOT NULL VARCHAR2(30) -
INDEX_NAME NOT NULL CHAR(1) -
INDEX_TYPE NOT NULL CHAR(1) " "
TABLE_OWNER NOT NULL VARCHAR2(30) -
TABLE_NAME NOT NULL VARCHAR2(30) -
TABLE_TYPE NOT NULL CHAR(5) "TABLE"
UNIQUENESS - VARCHAR2(9) "UNIQUE" or "NONUNIQUE"
COMPRESSION NOT NULL CHAR(1) " "
PREFIX_LENGTH NOT NULL NUMBER(10) 0
TABLESPACE_NAME NOT NULL CHAR(1) " "
INI_TRANS NOT NULL NUMBER(10) 0
MAX_TRANS NOT NULL NUMBER(10) 0
INITIAL_EXTENT NOT NULL NUMBER(10) 0
NEXT_EXTENT NOT NULL NUMBER(10) 0
MIN_EXTENTS NOT NULL NUMBER(10) 0
MAX_EXTENTS NOT NULL NUMBER(10) 0
PCT_INCREASE NOT NULL NUMBER(10) 0
PCT_THRESHOLD NOT NULL NUMBER(10) 0
INCLUDE_COLUMNS NOT NULL NUMBER(10) 0
FREELISTS NOT NULL NUMBER(10) 0
FREELIST_GROUPS NOT NULL NUMBER(10) 0
PCT_FREE NOT NULL NUMBER(10) 0
LOGGING NOT NULL CHAR(1) " "
BLEVEL NOT NULL NUMBER(10) 0
LEAF_BLOCKS NOT NULL NUMBER(10) 0
DISTINCT_KEYS - FLOAT(49) -
AVG_LEAF_BLOCKS_PER_KEY NOT NULL NUMBER(10) 0
AVG_DATA_BLOCKS_PER_KEY NOT NULL NUMBER(10) 0
CLUSTERING_FACTOR NOT NULL NUMBER(10) 0
STATUS NOT NULL CHAR(1) " "
NUM_ROWS NOT NULL NUMBER(10) 0
SAMPLE_SIZE NOT NULL NUMBER(10) 0
LAST_ANALYZED - DATE NULL
DEGREE NOT NULL CHAR(1) " "
INSTANCES NOT NULL CHAR(1) " "
PARTITIONED NOT NULL CHAR(1) " "
TEMPORARY NOT NULL CHAR(1) " "
GENERATED NOT NULL CHAR(1) " "
SECONDARY NOT NULL CHAR(1) " "
BUFFER_POOL NOT NULL CHAR(1) " "
USER_STATS NOT NULL CHAR(1) " "
DURATION NOT NULL CHAR(1) " "
PCT_DIRECT_ACCESS NOT NULL NUMBER(10) 0
ITYP_OWNER NOT NULL CHAR(1) " "
ITYP_NAME NOT NULL CHAR(1) " "
PARAMETERS NOT NULL CHAR(1) " "
GLOBAL_STATS NOT NULL CHAR(1) " "
DOMIDX_STATUS NOT NULL CHAR(1) " "
DOMIDX_OPSTATUS NOT NULL CHAR(1) " "
FUNCIDX_STATUS NOT NULL CHAR(1) " "

Table C-8 ALL_OBJECTS

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

Table C-9  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 NOT NULL CHAR(1) " "
DATA_TYPE_OWNER NOT NULL CHAR(1) " "
DATA_LENGTH NOT NULL FLOAT(49) -
DATA_PRECISION - FLOAT(49) -
DATA_SCALE - FLOAT(49) -
NULLABLE - VARCHAR2(1) "Y" or "N"
COLUMN_ID NOT NULL FLOAT(49) -
DEFAULT_LENGTH NOT NULL NUMBER(10) 0
DATA_DEFAULT NOT NULL CHAR(1) " "
NUM_DISTINCT NOT NULL NUMBER(10) 0
LOW_VALUE NOT NULL NUMBER(10) 0
HIGH_VALUE NOT NULL NUMBER(10) 0
DENSITY NOT NULL NUMBER(10) 0
NUM_NULLS NOT NULL NUMBER(10) 0
NUM_BUCKETS NOT NULL NUMBER(10) 0
LAST_ANALYZED - DATE NULL
SAMPLE_SIZE NOT NULL NUMBER(10) 0
CHARACTER_SET_NAME NOT NULL CHAR(1) " "
CHAR_COL_DECL_LENGTH NOT NULL NUMBER(10) 0
GLOBAL_STATS NOT NULL CHAR(1) " "
USER_STATS NOT NULL CHAR(1) " "
AVG_COL_LEN NOT NULL NUMBER(10) 0

Table C-10 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 NOT NULL CHAR(1) " "

Table C-11 ALL_TABLES

Name Null? Type Value
OWNER NOT NULL VARCHAR2(30) -
TABLE_NAME NOT NULL VARCHAR2(30) -
TABLESPACE_NAME NOT NULL CHAR(1) " "
CLUSTER_NAME NOT NULL CHAR(1) " "
IOT_NAME NOT NULL CHAR(1) " "
PCT_FREE NOT NULL NUMBER(10) 0
PCT_USED NOT NULL NUMBER(10) 0
INI_TRANS NOT NULL NUMBER(10) 0
MAX_TRANS NOT NULL NUMBER(10) 0
INITIAL_EXTENT NOT NULL NUMBER(10) 0
NEXT_EXTENT NOT NULL NUMBER(10) 0
MIN_EXTENTS NOT NULL NUMBER(10) 0
MAX_EXTENTS NOT NULL NUMBER(10) 0
PCT_INCREASE NOT NULL NUMBER(10) 0
FREELISTS NOT NULL NUMBER(10) 0
FREELIST_GROUPS NOT NULL NUMBER(10) 0
LOGGING NOT NULL CHAR(1) " "
BACKED_UP NOT NULL CHAR(1) " "
NUM_ROWS - FLOAT(49) -
BLOCKS - FLOAT(49) -
EMPTY_BLOCKS NOT NULL NUMBER(10) 0
AVG_SPACE NOT NULL NUMBER(10) 0
CHAIN_CNT NOT NULL NUMBER(10) 0
AVG_ROW_LEN NOT NULL NUMBER(10) 0
AVG_SPACE_FREELIST_BLOCKS NOT NULL NUMBER(10) 0
NUM_FREELIST_BLOCKS NOT NULL NUMBER(10) 0
DEGREE NOT NULL CHAR(1) " "
INSTANCES NOT NULL CHAR(1) " "
CACHE NOT NULL CHAR(1) " "
TABLE_LOCK NOT NULL CHAR(1) " "
SAMPLE_SIZE NOT NULL NUMBER(10) 0
LAST_ANALYZED - DATE NULL
PARTITIONED NOT NULL CHAR(1) " "
IOT_TYPE NOT NULL CHAR(1) " "
TEMPORARY NOT NULL CHAR(1) " "
SECONDARY NOT NULL CHAR(1) " "
NESTED NOT NULL CHAR(1) " "
BUFFER_POOL NOT NULL CHAR(1) " "
ROW_MOVEMENT NOT NULL CHAR(1) " "
GLOBAL_STATS NOT NULL CHAR(1) " "
USER_STATS NOT NULL CHAR(1) " "
DURATION NOT NULL CHAR(1) " "
SKIP_CORRUPT NOT NULL CHAR(1) " "
MONITORING NOT NULL CHAR(1) " "

Table C-12 ALL_USERS

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

Table C-13 ALL_VIEWS

Name Null? Type Value
OWNER NOT NULL VARCHAR2(30) -
VIEW_NAME NOT NULL VARCHAR2(30) -
TEXT_LENGTH NOT NULL NUMBER(10) 0
TEXT NOT NULL CHAR(1) " "
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 C-14 DBA_CATALOG

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

Table C-15 DBA_COL_COMMENTS

Name Null? Type Value
OWNER NOT NULL VARCHAR2(30) -
TABLE_NAME NOT NULL VARCHAR2(30) -
COLUMN_NAME NOT NULL VARCHAR2(30) -
COMMENTS NOT NULL CHAR(1) " "

Table C-16 DBA_OBJECTS

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

Table C-17  DBA_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 NOT NULL CHAR(1) " "
DATA_TYPE_OWNER NOT NULL CHAR(1) " "
DATA_LENGTH NOT NULL FLOAT(49) -
DATA_PRECISION - FLOAT(49) -
DATA_SCALE - FLOAT(49) -
NULLABLE - VARCHAR2(1) "Y" or "N"
COLUMN_ID NOT NULL FLOAT(49) -
DEFAULT_LENGTH NOT NULL NUMBER(10) 0
DATA_DEFAULT NOT NULL CHAR(1) " "
NUM_DISTINCT NOT NULL NUMBER(10) 0
LOW_VALUE NOT NULL NUMBER(10) 0
HIGH_VALUE NOT NULL NUMBER(10) 0
DENSITY NOT NULL NUMBER(10) 0
NUM_NULLS NOT NULL NUMBER(10) 0
NUM_BUCKETS NOT NULL NUMBER(10) 0
LAST_ANALYZED - DATE NULL
SAMPLE_SIZE NOT NULL NUMBER(10) 0
CHARACTER_SET_NAME NOT NULL CHAR(1) " "
CHAR_COL_DECL_LENGTH NOT NULL NUMBER(10) 0
GLOBAL_STATS NOT NULL CHAR(1) " "
USER_STATS NOT NULL CHAR(1) " "
AVG_COL_LEN NOT NULL NUMBER(10) 0

Table C-18 DBA_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 NOT NULL CHAR(1) " "

Table C-19 DBA_TABLES

Name Null? Type Value
OWNER NOT NULL VARCHAR2(30) -
TABLE_NAME NOT NULL VARCHAR2(30) -
TABLESPACE_NAME NOT NULL CHAR(1) " "
CLUSTER_NAME NOT NULL CHAR(1) " "
IOT_NAME NOT NULL CHAR(1) " "
PCT_FREE NOT NULL NUMBER(10) 0
PCT_USED NOT NULL NUMBER(10) 0
INI_TRANS NOT NULL NUMBER(10) 0
MAX_TRANS NOT NULL NUMBER(10) 0
INITIAL_EXTENT NOT NULL NUMBER(10) 0
NEXT_EXTENT NOT NULL NUMBER(10) 0
MIN_EXTENTS NOT NULL NUMBER(10) 0
MAX_EXTENTS NOT NULL NUMBER(10) 0
PCT_INCREASE NOT NULL NUMBER(10) 0
FREELISTS NOT NULL NUMBER(10) 0
FREELIST_GROUPS NOT NULL NUMBER(10) 0
LOGGING NOT NULL CHAR(1) " "
BACKED_UP NOT NULL CHAR(1) " "
NUM_ROWS - FLOAT(49) -
BLOCKS - FLOAT(49) -
EMPTY_BLOCKS NOT NULL NUMBER(10) 0
AVG_SPACE NOT NULL NUMBER(10) 0
CHAIN_CNT NOT NULL NUMBER(10) 0
AVG_ROW_LEN NOT NULL NUMBER(10) 0
AVG_SPACE_FREELIST_BLOCKS NOT NULL NUMBER(10) 0
NUM_FREELIST_BLOCKS NOT NULL NUMBER(10) 0
DEGREE NOT NULL CHAR(1) " "
INSTANCES NOT NULL CHAR(1) " "
CACHE NOT NULL CHAR(1) " "
TABLE_LOCK NOT NULL CHAR(1) " "
SAMPLE_SIZE NOT NULL NUMBER(10) 0
LAST_ANALYZED - DATE NULL
PARTITIONED NOT NULL CHAR(1) " "
IOT_TYPE NOT NULL CHAR(1) " "
TEMPORARY NOT NULL CHAR(1) " "
SECONDARY NOT NULL CHAR(1) " "
NESTED NOT NULL CHAR(1) " "
BUFFER_POOL NOT NULL CHAR(1) " "
ROW_MOVEMENT NOT NULL CHAR(1) " "
GLOBAL_STATS NOT NULL CHAR(1) " "
USER_STATS NOT NULL CHAR(1) " "
DURATION NOT NULL CHAR(1) " "
SKIP_CORRUPT NOT NULL CHAR(1) " "
MONITORING NOT NULL CHAR(1) " "

Table C-20 DICT_COLUMNS

Name Null? Type Value
TABLE_NAME NOT NULL VARCHAR2(30) -
COLUMN_NAME NOT NULL VARCHAR2(30) -
COMMENTS NOT NULL CHAR(1) " "

Table C-21 DICTIONARY

Name Null? Type Value
TABLE_NAME NOT NULL VARCHAR2(30) -
COMMENTS NOT NULL CHAR(1) " "

Table C-22 DUAL

Name Null? Type Value
DUMMY NOT NULL VARCHAR2(1) "X"

Table C-23 USER_CATALOG

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

Table C-24 USER_COL_COMMENTS

Name Null? Type Value
TABLE_NAME NOT NULL VARCHAR2(30) -
COLUMN_NAME NOT NULL VARCHAR2(30) -
COMMENTS NOT NULL CHAR(1) " "

Table C-25 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(8192) -
POSITION - FLOAT(49) -

Table C-26 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 NOT NULL CHAR(1) " "
R_OWNER NOT NULL VARCHAR2(30) -
R_CONSTRAINT_NAME NOT NULL VARCHAR2(30) -
DELETE_RULE NOT NULL VARCHAR2(9) " "
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 NULL

Table C-27 USER_IND_COLUMNS

Name Null? Type Value
INDEX_NAME NOT NULL VARCHAR2(30) -
TABLE_NAME NOT NULL VARCHAR2(30) -
COLUMN_NAME NOT NULL VARCHAR2(8192) -
COLUMN_POSITION NOT NULL FLOAT(49) -
COLUMN_LENGTH NOT NULL FLOAT(49) -
DESCEND NOT NULL VARCHAR2(4) "DESC" or "ASC"

Table C-28 USER_INDEXES

Name Null? Type Value
INDEX_NAME NOT NULL VARCHAR2(30) -
INDEX_TYPE NOT NULL CHAR(1) " "
TABLE_OWNER NOT NULL VARCHAR2(30) -
TABLE_NAME NOT NULL VARCHAR2(30) -
TABLE_TYPE NOT NULL CHAR(5) "TABLE"
UNIQUENESS - VARCHAR2(9) "UNIQUE" or "NONUNIQUE"
COMPRESSION NOT NULL CHAR(1) " "
PREFIX_LENGTH NOT NULL NUMBER(10) 0
TABLESPACE_NAME NOT NULL CHAR(1) " "
INI_TRANS NOT NULL NUMBER(10) 0
MAX_TRANS NOT NULL NUMBER(10) 0
INITIAL_EXTENT NOT NULL NUMBER(10) 0
NEXT_EXTENT NOT NULL NUMBER(10) 0
MIN_EXTENTS NOT NULL NUMBER(10) 0
MAX_EXTENTS NOT NULL NUMBER(10) 0
PCT_INCREASE NOT NULL NUMBER(10) 0
PCT_THRESHOLD NOT NULL NUMBER(10) 0
INCLUDE_COLUMNS NOT NULL NUMBER(10) 0
FREELISTS NOT NULL NUMBER(10) 0
FREELIST_GROUPS NOT NULL NUMBER(10) 0
PCT_FREE NOT NULL NUMBER(10) 0
LOGGING NOT NULL CHAR(1) " "
BLEVEL NOT NULL NUMBER(10) 0
LEAF_BLOCKS NOT NULL NUMBER(10) 0
DISTINCT_KEYS - FLOAT(49) -
AVG_LEAF_BLOCKS_PER_KEY NOT NULL NUMBER(10) 0
AVG_DATA_BLOCKS_PER_KEY NOT NULL NUMBER(10) 0
CLUSTERING_FACTOR NOT NULL NUMBER(10) 0
STATUS NOT NULL CHAR(1) " "
NUM_ROWS NOT NULL NUMBER(10) 0
SAMPLE_SIZE NOT NULL NUMBER(10) 0
LAST_ANALYZED - DATE NULL
DEGREE NOT NULL CHAR(1) " "
INSTANCES NOT NULL CHAR(1) " "
PARTITIONED NOT NULL CHAR(1) " "
TEMPORARY NOT NULL CHAR(1) " "
GENERATED NOT NULL CHAR(1) " "
SECONDARY NOT NULL CHAR(1) " "
BUFFER_POOL NOT NULL CHAR(1) " "
USER_STATS NOT NULL CHAR(1) " "
DURATION NOT NULL CHAR(1) " "
PCT_DIRECT_ACCESS NOT NULL NUMBER(10) 0
ITYP_OWNER NOT NULL CHAR(1) " "
ITYP_NAME NOT NULL CHAR(1) " "
PARAMETERS NOT NULL CHAR(1) " "
GLOBAL_STATS NOT NULL CHAR(1) " "
DOMIDX_STATUS NOT NULL CHAR(1) " "
DOMIDX_OPSTATUS NOT NULL CHAR(1) " "
FUNCIDX_STATUS NOT NULL CHAR(1) " "

Table C-29 USER_OBJECTS

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

Table C-30 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 NOT NULL CHAR(1) " "
DATA_TYPE_OWNER NOT NULL CHAR(1) " "
DATA_LENGTH NOT NULL FLOAT(49) -
DATA_PRECISION - FLOAT(49) -
DATA_SCALE - FLOAT(49) -
NULLABLE - VARCHAR2(1) "Y" or "N"
COLUMN_ID NOT NULL FLOAT(49) -
DEFAULT_LENGTH NOT NULL NUMBER(10) 0
DATA_DEFAULT NOT NULL CHAR(1) " "
NUM_DISTINCT NOT NULL NUMBER(10) 0
LOW_VALUE NOT NULL NUMBER(10) 0
HIGH_VALUE NOT NULL NUMBER(10) 0
DENSITY NOT NULL NUMBER(10) 0
NUM_NULLS NOT NULL NUMBER(10) 0
NUM_BUCKETS NOT NULL NUMBER(10) 0
LAST_ANALYZED - DATE NULL
SAMPLE_SIZE NOT NULL NUMBER(10) 0
CHARACTER_SET_NAME NOT NULL CHAR(1) " "
CHAR_COL_DECL_LENGTH NOT NULL NUMBER(10) 0
GLOBAL_STATS NOT NULL CHAR(1) " "
USER_STATS NOT NULL CHAR(1) " "
AVG_COL_LEN NOT NULL NUMBER(10) 0

Table C-31 USER_TAB_COMMENTS

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

Table C-32 USER_TABLES

Name Null? Type Value
TABLE_NAME NOT NULL VARCHAR2(30) -
TABLESPACE_NAME NOT NULL CHAR(1) " "
CLUSTER_NAME NOT NULL CHAR(1) " "
IOT_NAME NOT NULL CHAR(1) " "
PCT_FREE NOT NULL NUMBER(10) 0
PCT_USED NOT NULL NUMBER(10) 0
INI_TRANS NOT NULL NUMBER(10) 0
MAX_TRANS NOT NULL NUMBER(10) 0
INITIAL_EXTENT NOT NULL NUMBER(10) 0
NEXT_EXTENT NOT NULL NUMBER(10) 0
MIN_EXTENTS NOT NULL NUMBER(10) 0
MAX_EXTENTS NOT NULL NUMBER(10) 0
PCT_INCREASE NOT NULL NUMBER(10) 0
FREELISTS NOT NULL NUMBER(10) 0
FREELIST_GROUPS NOT NULL NUMBER(10) 0
LOGGING NOT NULL CHAR(1) " "
BACKED_UP NOT NULL CHAR(1) " "
NUM_ROWS - FLOAT(49) -
BLOCKS NOT NULL FLOAT(49) -
EMPTY_BLOCKS NOT NULL NUMBER(10) 0
AVG_SPACE NOT NULL NUMBER(10) 0
CHAIN_CNT NOT NULL NUMBER(10) 0
AVG_ROW_LEN NOT NULL NUMBER(10) 0
AVG_SPACE_FREELIST_BLOCKS NOT NULL NUMBER(10) 0
NUM_FREELIST_BLOCKS NOT NULL NUMBER(10) 0
DEGREE NOT NULL CHAR(1) " "
INSTANCES NOT NULL CHAR(1) " "
CACHE NOT NULL CHAR(1) " "
TABLE_LOCK NOT NULL CHAR(1) " "
SAMPLE_SIZE NOT NULL NUMBER(10) 0
LAST_ANALYZED - DATE NULL
PARTITIONED NOT NULL CHAR(1) " "
IOT_TYPE NOT NULL CHAR(1) " "
TEMPORARY NOT NULL CHAR(1) " "
SECONDARY NOT NULL CHAR(1) " "
NESTED NOT NULL CHAR(1) " "
BUFFER_POOL NOT NULL CHAR(1) " "
ROW_MOVEMENT NOT NULL CHAR(1) " "
GLOBAL_STATS NOT NULL CHAR(1) " "
USER_STATS NOT NULL CHAR(1) " "
DURATION NOT NULL CHAR(1) " "
SKIP_CORRUPT NOT NULL CHAR(1) " "
MONITORING NOT NULL CHAR(1) " "

Table C-33 USER_USERS

Name Null? Type Value
USERNAME NOT NULL VARCHAR2(30) -
USER_ID - NUMBER 0
ACCOUNT_STATUS - VARCHAR2(4) "OPEN"
LOCK_DATE - DATE NULL
EXPIRY_DATE - DATE NULL
DEFAULT_TABLESPACE - VARCHAR2(1) NULL
TEMPORARY_TABLESPACE - VARCHAR2(1) NULL
CREATED - DATE NULL
INITIAL_RSRC_CONSUMER_GROUP - VARCHAR2(1) NULL
EXTERNAL_NAME - VARCHAR2(1) NULL

Table C-34 USER_VIEWS

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

Go to previous page
Previous		 Go to next page
Next
Go to Documentation Home
Home		 Go to Book List
Book List		 Go to Table of Contents
Contents		 Go to Index
Index		 Go to Master Index
Master Index		 Go to Feedback page
Feedback