Oracle Transparent Gateway Microsoft SQL Server Administrator's Guide Release 8.1.6 for Windows NT Part Number A82868-01 |
| Library | Contents | Index

# B
Data Dictionary

The Oracle Transparent Gateway for Microsoft SQL Server translates a query that refers to an Oracle database server data dictionary table into a query that retrieves the data from a Microsoft SQL Server data dictionary. 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:

- Data Dictionary Support

- Data Dictionary Mapping

- Gateway Data Dictionary Descriptions

## Data Dictionary Support

### Microsoft SQL Server System Tables

Microsoft SQL Server data dictionary information is stored in the Microsoft SQL Server database as Microsoft SQL Server system tables. All Microsoft SQL Server system tables have names prefaced with "dbo". The Microsoft SQL Server system tables define the structure of a database. When you change data definitions, Microsoft SQL Server reads and modifies the Microsoft SQL Server system tables to add information about the user tables.

### 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. Synonyms of supported views are also acceptable. For example, the following statement queries the data dictionary table ALL_TABLES to retrieve all table names in the Microsoft SQL Server database:

    SQL> SELECT * FROM "ALL_TABLES"@MSQL;

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

1. Maps the requested table, view, or synonym to one or more Microsoft SQL Server system table names. The gateway translates all data dictionary column names to their corresponding Microsoft SQL Server column names within the query. If the mapping involves one Microsoft SQL Server system table, the gateway translates the requested table name to its corresponding Microsoft SQL Server system table name within the query. If the mapping involves multiple Microsoft SQL Server system tables, the gateway constructs a join in the query using the translated Microsoft SQL Server system table names.

2. Sends the translated query to Microsoft SQL Server.

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

4. Passes the data dictionary information from the translated Microsoft SQL Server system 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.

### Direct Queries to Microsoft SQL Server Tables

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

### Supported Views and Tables

The gateway supports the following views and tables:

##### Table B-1 Gateway Supported Views and Tables

ALL_CATALOG | ALL_COL_COMMENTS
ALL_CONS_COLUMNS | ALL_CONSTRAINTS
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_INDEXES
USER_OBJECTS | USER_TAB_COLUMNS
USER_TAB_COMMENTS | USER_TABLES
USER_USERS | 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 the supported data dictionary tables and views beginning with the characters ALL_ might return rows from the Microsoft SQL Server database when you do not have access privileges for those Microsoft SQL Server 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 Microsoft SQL Server system table names. A plus sign (+) indicates that a join operation is involved.

##### Table B-2 Oracle Data Dictionary View Names and SQL Server Equivalents

View Name | Microsoft SQL Server System Table Name
--- | ---
ALL_CATALOG | sysusers + sysobjects
ALL_COL_COMMENTS | sysusers+sysobjects+syscolumns
ALL_CONS_COLUMNS | sp_pkeys + sp_fkeys
ALL_CONSTRAINTS | sysusers + sysobjects + sysindexes + sysconstraints + sysreferences
ALL_INDEXES | sysusers + sysindexes + sysobjects
ALL_OBJECTS | sysusers + sysobjects + sysindexes
ALL_TAB_COLUMNS | sysusers + sysobjects + syscolumns
ALL_TAB_COMMENTS | sysusers + sysobjects
ALL_TABLES | sysusers + sysobjects
ALL_USERS | sysusers
ALL_VIEWS | sysusers + sysobjects + syscomments
DBA_CATALOG | sysusers + sysobjects
DBA_COL_COMMENTS | sysusers + sysobjects + syscolumns
DBA_OBJECTS | sysusers + sysobjects + sysindexes
DBA_TABLES | sysusers + sysobjects
DBA_TAB_COLUMNS | sysusers + sysobjects + syscolumns
DBA_TAB_COMMENTS | sysusers + sysobjects
DICT_COLUMNS | sysobjects + syscolumns
DICTIONARY | sysobjects
DUAL | sysusers
TABLE_PRIVILEGES | sysprotects + sysusers + sysobjects
USER_CATALOG | sysusers + sysobjects
USER_COL_COMMENTS | sysusers + sysobjects + syscolumns
USER_CONS_COLUMNS | sp_pkeys + sp_fkeys
USER_CONSTRAINTS | sysusers + sysobjects + sysindexes + sysconstraints + sysreferences
USER_INDEXES | sysusers + sysindexes + sysobjects
USER_OBJECTS | sysusers + sysobjects + sysindexes
USER_TAB_COLUMNS | sysusers + sysobjects + syscolumns
USER_TAB_COMMENTS | sysusers + sysobjects
USER_TABLES | sysusers + sysobjects
USER_USERS | sysusers
USER_VIEWS | sysusers + sysobjects + syscomments

### 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 a Microsoft SQL Server data dictionary table are filled with zeros, spaces, null values, not-applicable values (N.A.), or default values, depending on the column type.

## Gateway Data Dictionary Descriptions

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

- Name, datatype, and width of each column

- The contents of columns with fixed values

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

Note: The column width of some columns in the translated data dictionary tables would be different when the gateway connects to a Microsoft SQL Server Version 7.0 database.

##### Table B-3 ALL_CATALOG

Name | Null? | Type | Value
--- | --- | --- | ---
OWNER | NOT NULL | VARCHAR2(255) |
TABLE_NAME | NOT NULL | VARCHAR2(255) |
TABLE_TYPE |  | VARCHAR2(5) | "TABLE" or "VIEW"

##### Table B-4 ALL_COL_COMMENTS

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

##### Table B-5 ALL_CONS_COLUMNS

Name | Null? | Type | Value
--- | --- | --- | ---
OWNER |  | VARCHAR2(30) |
CONSTRAINT_NAME |  | VARCHAR2(30) |
TABLE_NAME |  | VARCHAR2(30) |
COLUMN_NAME |  | VARCHAR2(4000) |
POSITION |  | NUMBER |

##### Table B-6 ALL_CONSTRAINTS

Name | Null? | Type | Value
--- | --- | --- | ---
OWNER |  | VARCHAR2(255) |
CONSTRAINT_NAME |  | VARCHAR2(255) |
CONSTRAINT_TYPE |  | VARCHAR2(1) | "C" or "P" or "R" or "U"
TABLE_NAME |  | VARCHAR2(255) |
SEARCH_CONDITION |  | VARCHAR2(1) | NULL
R_OWNER |  | VARCHAR2(255) |
R_CONSTRAINT_NAME |  | VARCHAR2(255) |
DELETE_RULE |  | VARCHAR2(1) | NULL
STATUS |  | VARCHAR2(1) | NULL
DEFERRABLE |  | VARCHAR2(1) | NULL
DEFERRED |  | VARCHAR2(1) | NULL
VALIDATED |  | VARCHAR2(1) | NULL
GENERATED |  | VARCHAR2(1) | NULL
BAD |  | VARCHAR2(1) | NULL
RELY |  | VARCHAR2(1) | NULL
LAST_CHANGE |  | DATE |

##### Table B-7 ALL_INDEXES

Name | Null? | Type | Value
--- | --- | --- | ---
OWNER | NOT NULL | VARCHAR2(255) |
INDEX_NAME |  | VARCHAR2(255) |
INDEX_TYPE |  | VARCHAR2(1) | NULL
TABLE_OWNER | NOT NULL | VARCHAR2(255) |
TABLE_NAME | NOT NULL | VARCHAR2(255) |
TABLE_TYPE |  | VARCHAR(7) | "TABLE" or "CLUSTER"
UNIQUENESS |  | VARCHAR2(1) | NULL
COMPRESSION |  | VARCHAR2(1) | NULL
PREFIX_LENGTH |  | NUMBER | 0
TABLESPACE_NAME |  | VARCHAR2(1) | 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_COLUMN |  | NUMBER | 0
FREELISTS |  | NUMBER | 0
FREELIST_GROUPS |  | NUMBER | 0
PCT_FREE |  | NUMBER | 0
LOGGING |  | VARCHAR2(1) | NULL
BLEVEL |  | NUMBER | 0
LEAF_BLOCKS |  | NUMBER | 0
DISTINCT_KEYS |  | NUMBER | 0
AVG_LEAF_BLOCKS_PER_KEY |  | NUMBER | 0
AVG_DATA_BLOCKS_PER_KEY |  | NUMBER | 0
CLUSTERING_FACTOR |  | NUMBER | 0
STATUS |  | VARCHAR2(1) | NULL
NUM_ROWS |  | NUMBER | 0
SAMPLE_SIZE |  | NUMBER | 0
LAST_ANALYZED |  | VARCHAR2(0) | NULL
DEGREE |  | VARCHAR2(1) | NULL
INSTANCES |  | VARCHAR2(1) | NULL
PARTITIONED |  | VARCHAR2(1) | NULL
TEMPORARY |  | VARCHAR2(1) | NULL
GENERATED |  | VARCHAR2(1) | NULL
SECONDARY |  | VARCHAR2(1) | NULL
BUFFER_POOL |  | VARCHAR2(1) | NULL
USER_STATS |  | VARCHAR2(1) | NULL
DURATION |  | VARCHAR2(1) | NULL
PCT_DIRECT_ACCESS |  | NUMBER | 0
ITYP_OWNER |  | VARCHAR2(1) | NULL
ITYP_NAME |  | VARCHAR2(1) | NULL
PARAMETERS |  | VARCHAR2(1) | NULL
GLOBAL_STATS |  | VARCHAR2(1) | NULL
DOMIDX_STATUS |  | VARCHAR2(1) | NULL
DOMIDX_OPSTATUS |  | VARCHAR2(1) | NULL
FUNCIDX_STATUS |  | VARCHAR2(1) | NULL

##### Table B-8 ALL_OBJECTS

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

##### Table B-9 ALL_TAB_COLUMNS

Name | Null? | Type | Value
--- | --- | --- | ---
OWNER |  | VARCHAR2(255) |
TABLE_NAME |  | VARCHAR2(255) |
COLUMN_NAME |  | VARCHAR2(255) |
DATA_TYPE |  | VARCHAR2(8) |
DATA_TYPE_MOD |  | VARCHAR2(1) | NULL
DATA_TYPE_OWNER |  | VARCHAR2(1) | 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 |  | VARCHAR2(1) | NULL
NUM_DISTINCT |  | NUMBER | 0
LOW_VALUE |  | NUMBER | 0
HIGH_VALUE |  | NUMBER | 0
DENSITY |  | NUMBER | 0
NUM_NULLS |  | NUMBER | 0
NUM_BUCKETS |  | NUMBER | 0
LAST_ANALYZED |  | VARCHAR2(0) | NULL
SAMPLE_SIZE |  | NUMBER | 0
CHARACTER_SET_NAME |  | VARCHAR2(1) | NULL
CHAR_COL_DEC_LENGTH |  | NUMBER | 0
GLOBAL_STATS |  | VARCHAR2(1) | NULL
USER_STATS |  | VARCHAR2(1) | NULL
AVG_COL_LEN |  | NUMBER | 0

##### Table B-10 ALL_TAB_COMMENTS

Name | Null? | Type | Value
--- | --- | --- | ---
OWNER | NOT NULL | VARCHAR2(255) |
TABLE_NAME | NOT NULL | VARCHAR2(255) |
TABLE_TYPE |  | VARCHAR2(5) | "TABLE" or "VIEW"
COMMENTS |  | VARCHAR2(1) | NULL

##### Table B-11 ALL_TABLES

Name | Null? | Type | Value
--- | --- | --- | ---
OWNER | NOT NULL | VARCHAR2(255) |
TABLE_NAME | NOT NULL | VARCHAR2(255) |
TABLESPACE_NAME |  | VARCHAR2(1) | NULL
CLUSTER_NAME |  | VARCHAR2(1) | NULL
IOT_NAME |  | VARCHAR2(1) | 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(1) | NULL
BACKED_UP |  | VARCHAR2(1) | NULL
NUM_ROWS |  | NUMBER | 0
BLOCKS |  | NUMBER | 0
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(1) | NULL
INSTANCES |  | VARCHAR2(1) | NULL
CACHE |  | VARCHAR2(1) | NULL
TABLE_LOCK |  | VARCHAR2(1) | NULL
SAMPLE_SIZE |  | NUMBER | 0
LAST_ANALYZED |  | VARCHAR2(0) | NULL
PARTITIONED |  | VARCHAR2(1) | NULL
IOT_TYPE |  | VARCHAR2(1) | NULL
TEMPORARY |  | VARHCAR2(1) | NULL
SECONDARY |  | VARCHAR2(1) | NULL
NESTED |  | VARCHAR2(1) | NULL
BUFFER_POOL |  | VARCHAR2(1) | NULL
ROW_MOVEMENT |  | VARCHAR2(1) | NULL
GLOBAL_STATS |  | VARCHAR2(1) | NULL
USER_STATS |  | VARCHAR2(1) | NULL
DURATION |  | VARHCAR2(1) | NULL
SKIP_CORRUPT |  | VARCHAR2(1) | NULL
MONITORING |  | VARCHAR2(1) | NULL

##### Table B-12 ALL_USERS

Name | Null? | Type | Value
--- | --- | --- | ---
USERNAME | NOT NULL | VARCHAR2(255) |
USER_ID | NOT NULL | NUMBER(5) |
CREATED |  | VARCHAR2(0) | NULL

##### Table B-13 ALL_VIEWS

Name | Null? | Type | Value
--- | --- | --- | ---
OWNER | NOT NULL | VARCHAR2(255) |
VIEW_NAME | NOT NULL | VARCHAR2(255) |
TEXT_LENGTH | NOT NULL | NUMBER(10) | 0
TEXT |  | VARCHAR2(255) |
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 B-14 DBA_CATALOG

Name | Null? | Type | Value
--- | --- | --- | ---
OWNER | NOT NULL | VARCHAR2(255) |
TABLE_NAME | NOT NULL | VARCHAR2(255) |
TABLE_TYPE |  | VARCHAR2(5) | "TABLE" or "VIEW"

##### Table B-15 DBA_COL_COMMENTS

Name | Null? | Type | Value
--- | --- | --- | ---
OWNER | NOT NULL | VARCHAR2(255) |
TABLE_NAME | NOT NULL | VARCHAR2(255) |
COLUMN_NAME | NOT NULL | VARCHAR2(255) |
COMMENTS | NOT NUL | CHAR(1) | NULL

##### Table B-16 DBA_OBJECTS

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

##### Table B-17 DBA_TAB_COLUMNS

Name | Null? | Type | Value
--- | --- | --- | ---
OWNER |  | VARCHAR2(255) |
TABLE_NAME |  | VARCHAR2(255) |
COLUMN_NAME |  | VARCHAR2(255) |
DATA_TYPE |  | VARCHAR2(8) |
DATA_TYPE_MOD |  | VARCHAR2(1) | NULL
DATA_TYPE_OWNER |  | VARCHAR2(1) | 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 |  | VARCHAR2(1) | NULL
NUM_DISTINCT |  | NUMBER | 0
LOW_VALUE |  | NUMBER | 0
HIGH_VALUE |  | NUMBER | 0
DENSITY |  | NUMBER | 0
NUM_NULLS |  | NUMBER | 0
NUM_BUCKETS |  | NUMBER | 0
LAST_ANALYZED |  | VARCHAR2(0) | NULL
SAMPLE_SIZE |  | NUMBER | 0
CHARACTER_SET_NAME |  | VARCHAR2(1) | NULL
CHAR_COL_DEC_LENGTH |  | NUMBER | 0
GLOBAL_STATS |  | VARCHAR2(1) | NULL
USER_STATS |  | VARCHAR2(1) | NULL
AVG_COL_LEN |  | NUMBER | 0

##### Table B-18 DBA_TAB_COMMENTS

Name | Null? | Type | Value
--- | --- | --- | ---
OWNER | NOT NULL | VARCHAR2(255) |
TABLE_NAME | NOT NULL | VARCHAR2(255) |
TABLE_TYPE |  | VARCHAR2(5) | "TABLE" or "VIEW"
COMMENTS |  | VARCHAR2(1) | NULL

##### Table B-19 DBA_TABLES

Name | Null? | Type | Value
--- | --- | --- | ---
OWNER | NOT NULL | VARCHAR2(255) |
TABLE_NAME | NOT NULL | VARCHAR2(255) |
TABLESPACE_NAME |  | VARCHAR2(1) | NULL
CLUSTER_NAME |  | VARCHAR2(1) | NULL
IOT_NAME |  | VARCHAR2(1) | 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(1) | NULL
BACKED_UP |  | VARCHAR2(1) | NULL
NUM_ROWS |  | NUMBER | 0
BLOCKS |  | NUMBER | 0
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(1) | NULL
INSTANCES |  | VARCHAR2(1) | NULL
CACHE |  | VARCHAR2(1) | NULL
TABLE_LOCK |  | VARCHAR2(1) | NULL
SAMPLE_SIZE |  | NUMBER | 0
LAST_ANALYZED |  | VARCHAR2(0) | NULL
PARTITIONED |  | VARCHAR2(1) | NULL
IOT_TYPE |  | VARCHAR2(1) | NULL
TEMPORARY |  | VARHCAR2(1) | NULL
SECONDARY |  | VARCHAR2(1) | NULL
NESTED |  | VARCHAR2(1) | NULL
BUFFER_POOL |  | VARCHAR2(1) | NULL
ROW_MOVEMENT |  | VARCHAR2(1) | NULL
GLOBAL_STATS |  | VARCHAR2(1) | NULL
USER_STATS |  | VARCHAR2(1) | NULL
DURATION |  | VARHCAR2(1) | NULL
SKIP_CORRUPT |  | VARCHAR2(1) | NULL
MONITORING |  | VARCHAR2(1) | NULL

##### Table B-20 DICT_COLUMNS

Name | Null? | Type | Value
--- | --- | --- | ---
TABLE_NAME | NOT NULL | VARCHAR2(255) |
COLUMN_NAME | NOT NULL | VARCHAR2(255) |
COMMENTS | NOT NULL | CHAR2(1) | NULL

##### Table B-21 DICTIONARY

Name | Null? | Type | Value
--- | --- | --- | ---
TABLE_NAME | NOT NULL | VARCHAR2(255) |
COMMENTS | NOT NULL | CHAR(1) |

##### Table B-22 DUAL

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

##### Table B-23 TABLE_PRIVILEGES

Name | Null? | Type | Value
--- | --- | --- | ---
GRANTEE | NOT NULL | VARCHAR2(255) |
OWNER | NOT NULL | VARCHAR2(255) |
TABLE_NAME | NOT NULL | VARCHAR2(255) |
GRANTOR | NOT NULL | VARCHAR2(255) |
SELECT_PRIV |  | VARCHAR2(1) | "Y"
INSERT_PRIV |  | VARCHAR2(1) | "A"
DELETE_PRIV |  | VARCHAR2(1) | "Y"
UPDATE_PRIV |  | VARCHAR2(1) | "A"
REFERENCES_PRIV |  | VARCHAR2(1) | "A"
ALTER_PRIV |  | VARCHAR2(1) | "Y"
INDEX_PRIV |  | VARCHAR2(1) | "Y"
CREATED |  | VARCHAR2(0) | NULL

##### Table B-24 USER_CATALOG

Name | Null? | Type | Value
--- | --- | --- | ---
TABLE_NAME | NOT NULL | VARCHAR2(255) |
TABLE_TYPE |  | VARCHAR2(5) | "TABLE" or "VIEW"

##### Table B-25 USER_COL_COMMENTS

Name | Null? | Type | Value
--- | --- | --- | ---
TABLE_NAME | NOT NULL | VARCHAR2(255) |
COLUMN_NAME | NOT NULL | VARCHAR2(255) |
COMMENTS |  | VARCHAR2(1) | NULL

##### Table B-26 USER_CONS_COLUMNS

Name | Null? | Type | Value
--- | --- | --- | ---
OWNER |  | VARCHAR2(30) |
CONSTRAINT_NAME |  | VARCHAR2(30) |
TABLE_NAME |  | VARCHAR2(30) |
COLUMN_NAME |  | VARCHAR2(4000) |
POSITION |  | NUMBER |

##### Table B-27 USER_CONSTRAINTS

Name | Null? | Type | Value
--- | --- | --- | ---
OWNER |  | VARCHAR2(255) |
CONSTRAINT_NAME |  | VARCHAR2(255) |
CONSTRAINT_TYPE |  | VARCHAR2(1) | "R" or "P" or "U" or "C"
TABLE_NAME |  | VARCHAR2(255) |
SEARCH_CONDITION |  | VARCHAR2(1) | NULL
R_OWNER |  | VARCHAR2(255) |
R_CONSTRAINT_NAME |  | VARCHAR2(255) |
DELETE_RULE |  | VARCHAR2(1) | NULL
STATUS |  | VARCHAR2(1) | NULL
DEFERRABLE |  | VARCHAR2(1) | NULL
DEFERRED |  | VARCHAR2(1) | NULL
VALIDATED |  | VARCHAR2(1) | NULL
GENERATED |  | VARCHAR2(1) | NULL
BAD |  | VARCHAR2(1) | NULL
RELY |  | VARCHAR2(1) | NULL
LAST_CHANGE |  | DATE | NULL

##### Table B-28 USER_INDEXES

Name | Null? | Type | Value
--- | --- | --- | ---
INDEX_NAME |  | VARCHAR2(255) |
INDEX_TYPE |  | VARCHAR2(1) | NULL
TABLE_OWNER | NOT NULL | VARCHAR2(255) |
TABLE_NAME | NOT NULL | VARCHAR2(255) |
TABLE_TYPE |  | VARCHAR2(7) | "TABLE" or "CLUSTER"
UNIQUENESS |  | VARCHAR2(1) | NULL
COMPRESSION |  | VARCHAR2(1) | NULL
PREFIX_LENGTH |  | NUMBER | 0
TABLESPACE_NAME |  | VARCHAR2(1) | 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_COLUMN |  | NUMBER | 0
FREELISTS |  | NUMBER | 0
FREELIST_GROUPS |  | NUMBER | 0
PCT_FREE |  | NUMBER | 0
LOGGING |  | VARCHAR2(1) | NULL
BLEVEL |  | NUMBER | 0
LEAF_BLOCKS |  | NUMBER | 0
DISTINCT_KEYS |  | NUMBER | 0
AVG_LEAF_BLOCKS_PER_KEY |  | NUMBER | 0
AVG_DATA_BLOCKS_PER_KEY |  | NUMBER | 0
CLUSTERING_FACTOR |  | NUMBER | 0
STATUS |  | VARCHAR2(1) | NULL
NUM_ROWS |  | NUMBER | 0
SAMPLE_SIZE |  | NUMBER | 0
LAST_ANALYZED |  | VARCHAR2(0) | NULL
DEGREE |  | VARCHAR2(1) | NULL
INSTANCES |  | VARCHAR2(1) | NULL
PARTITIONED |  | VARCHAR2(1) | NULL
TEMPORARY |  | VARCHAR2(1) | NULL
GENERATED |  | VARCHAR2(1) | NULL
SECONDARY |  | VARCHAR2(1) | NULL
BUFFER_POOL |  | VARCHAR2(1) | NULL
USER_STATS |  | VARCHAR2(1) | NULL
DURATION |  | VARHCAR2(1) | NULL
PCT_DIRECT_ACCESS |  | NUMBER | 0
ITYP_OWNER |  | VARCHAR2(1) | NULL
ITYP_NAME |  | VARCHAR2(1) | NULL
PARAMETERS |  | VARCHAR2(1) | NULL
GLOBAL_STATS |  | VARCHAR2(1) | NULL
DOMIDX_STATUS |  | VARCHAR2(1) | NULL
DOMIDX_OPSTATUS |  | VARCHAR2(1) | NULL
FUNCIDX_STATUS |  | VARCHAR2(1) | NULL

##### Table B-29 USER_OBJECTS

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

##### Table B-30 USER_TAB_COLUMNS

Name | Null? | Type | Value
--- | --- | --- | ---
TABLE_NAME |  | VARCHAR2(255) |
COLUMN_NAME |  | VARCHAR2(255) |
DATA_TYPE |  | VARCHAR2(8) |
DATA_TYPE_MOD |  | VARCHAR2(1) | NULL
DATA_TYPE_OWNER |  | VARCHAR2(1) | 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 |  | VARCHAR2(1) | NULL
NUM_DISTINCT |  | NUMBER | 0
LOW_VALUE |  | NUMBER | 0
HIGH_VALUE |  | NUMBER | 0
DENSITY |  | NUMBER | 0
NUM_NULLS |  | NUMBER | 0
NUM_BUCKETS |  | NUMBER | 0
LAST_ANALYZED |  | VARCHAR2(0) | NULL
SAMPLE_SIZE |  | NUMBER | 0
CHARACTER_SET_NAME |  | VARCHAR2(1) | NULL
CHAR_COL_DECL_LENGTH |  | NUMBER | 0
GLOBAL_STATS |  | VARCHAR2(1) | NULL
USER_STATS |  | VARCHAR2(1) | NULL
AVG_COL_LEN |  | NUMBER | 0

##### Table B-31 USER_TAB_COMMENTS

Name | Null? | Type | Value
--- | --- | --- | ---
TABLE_NAME | NOT NULL | VARCHAR2(255) |
TABLE_TYPE |  | VARCHAR2(5) | "TABLE" or "VIEW"
COMMENTS |  | VARCHAR2(1) | NULL

##### Table B-32 USER_TABLES

Name | Null? | Type | Value
--- | --- | --- | ---
TABLE_NAME | NOT NULL | VARCHAR2(255) |
TABLESPACE_NAME |  | VARCHAR2(1) | NULL
CLUSTER_NAME |  | VARCHAR2(1) | NULL
IOT_NAME |  | VARCHAR2(1) | 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(1) | NULL
BACKED_UP |  | VARCHAR2(1) | NULL
NUM_ROWS |  | NUMBER | 0
BLOCKS |  | NUMBER | 0
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(1) | NULL
INSTANCES |  | VARCHAR2(1) | NULL
CACHE |  | VARCHAR2(1) | NULL
TABLE_LOCK |  | VARCHAR2(1) | NULL
SAMPLE_SIZE |  | NUMBER | 0
LAST_ANALYZED |  | VARCHAR2(0) | NULL
PARTITIONED |  | VARCHAR2(1) | NULL
IOT_TYPE |  | VARCHAR2(1) | NULL
TEMPORARY |  | VARHCAR2(1) | NULL
SECONDARY |  | VARCHAR2(1) | NULL
NESTED |  | VARCHAR2(1) | NULL
BUFFER_POOL |  | VARCHAR2(1) | NULL
ROW_MOVEMENT |  | VARCHAR2(1) | NULL
GLOBAL_STATS |  | VARCHAR2(1) | NULL
USER_STATS |  | VARCHAR2(1) | NULL
DURATION |  | VARCHAR2(1) | NULL
SKIP_CORRUPT |  | VARCHAR2(1) | NULL
MONITORING |  | VARCHAR2(1) | NULL

##### Table B-33 USER_USERS

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

##### Table B-34 USER_VIEWS

Name | Null? | Type | Value
--- | --- | --- | ---
VIEW_NAME | NOT NULL | VARCHAR2(255) |
TEXT_LENGTH |  | NUMBER | 0
TEXT | NOT NULL | VARCHAR2(255) |
TYPE_TEXT_LENGTH |  | NUMBER | 0
TYPE_TEXT |  | VARCHAR2(1) | NULL
OID_TEXT_LENGTH |  | NUMBER | 0
OID_TEXT |  | VARCHAR2(1) | NULL
VIEW_TYPE_OWNER |  | VARCHAR2(1) | NULL
VIEW_TYPE |  | VARCHAR2(1) | NULL

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