|
Oracle® Transparent Gateway for Rdb Administrator's Guide
10g Release 1 (10.1) for HP OpenVMS Part No. B10537-01 |
|
 Previous |
 Next |
|
Oracle® Transparent Gateway for Rdb Administrator's Guide
10g Release 1 (10.1) for HP OpenVMS Part No. B10537-01 |
|
|
Previous |
Next |
The Oracle Transparent Gateway for Rdb translates a query that refers to an Oracle database server data dictionary table into a query that retrieves the data from Rdb 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:
Rdb data dictionary information is stored in the Rdb database as Rdb system catalog tables. All Rdb system catalog tables have names prefixed with "RDB$" or "RDBVMS$". The Rdb system catalog tables define the structure of a database. When you change data definitions, Rdb reads and modifies the Rdb system tables to add information about the user tables.
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_TABLES to retrieve all table names in the Rdb database:
SQL> SELECT * FROM ALL_TABLES@RDB;
When a data dictionary access query is issued, the gateway:
Maps the requested table, view, or synonym to one or more Rdb system table names. The gateway translates all data dictionary column names to their corresponding Rdb column names within the query. If the mapping involves one Rdb system table, the gateway translates the requested table name to its corresponding Rdb system table name within the query. If the mapping involves multiple Rdb system catalog tables, the gateway constructs a join in the query using the translated Rdb system catalog table names.
Sends the translated query to Rdb.
Might convert the retrieved Rdb data to give it the appearance of the Oracle database server data dictionary table.
Passes the data dictionary information from the translated Rdb 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 SQL*Plus DESCRIBE command. |
Queries issued directly to individual Rdb system tables are allowed but they return different results because the Rdb system table column names differ from those of the data dictionary view. Also, certain columns in a Rdb system table cannot be used in data dictionary processing.
The gateway supports the following views and tables:
| Views and Tables | Views and Tables |
|---|---|
| ALL_CONS_COLUMNS | ALL_CONSTRAINTS |
| ALL_IND_COLUMNS | ALL_INDEXES |
| ALL_OBJECTS | ALL_TAB_COLUMNS |
| ALL_TAB_COMMENTS | ALL_TABLES |
| ALL_TRIGGERS | ALL_VIEWS |
| DBA_CATALOG | DBA_COL_COMMENTS |
| DBA_OBJECTS | DBA_TABLES |
| DBA_TAB_COLUMNS | DBA_TAB_COMMENTS |
| DICT_COLUMNS | DICTIONARY |
| DUAL | 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_TRIGGERS |
| 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 Rdb database even when access privileges for those Rdb 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.
If you want to select 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
The tables in this section list Oracle data dictionary view names and the equivalent Rdb system table names. A plus sign (+) indicates that a join operation is involved.
Table C-1 Oracle Data Dictionary View Names and Rdb Equivalents
| View Name | Rdb System Table Name |
|---|---|
| ALL_CATALOG | rdb$relations |
| ALL_COL_COMMENTS | rdb$relations + rdb$relation_fields |
| ALL_CONS_COLUMNS | rdbvms$relation_constraints + rdbvms$relation_constraint_flds |
| ALL_CONSTRAINTS | rdbvms$relation_constraints |
| ALL_IND_COLUMNS | rdb$indices + rdb$index_segments |
| ALL_INDEXES | rdb$relations + rdb$indices |
| ALL_OBJECTS | rdb$relations + rdb$indices |
| ALL_TAB_COLUMNS | rdb$relation_fields + rdb$fields |
| ALL_TAB_COMMENTS | rdb$relations |
| ALL_TABLES | rdb$relations |
| ALL_TRIGGERS | rdbvms$triggers |
| ALL_VIEWS | rdb$view_relations |
| DBA_CATALOG | rdb$relations |
| DBA_COL_COMMENTS | rdb$relations + rdb$relation_fields |
| DBA_OBJECTS | rdb$relations + rdb$indices |
| DBA_TABLES | rdb$relations |
| DBA_TAB_COLUMNS | rdb$relation_fields + rdb$fields |
| DBA_TAB_COMMENTS | rdb$relations |
| DICT_COLUMNS | rdb$relations + rdb$relation_fields |
| DICTIONARY | rdb$relations |
| DUAL | rdb$relations |
| USER_CATALOG | rdb$relations |
| USER_COL_COMMENTS | rdb$relations + rdb$relation_fields |
| USER_CONS_COLUMNS | rdbvms$relation_constraints + rdbvms$relation_constraint_flds |
| USER_CONSTRAINTS | rdb$relations + rdbvms$relation_constraints |
| USER_IND_COLUMNS | rdb$relations + rdb$index_segments + rdb$indices |
| USER_INDEXES | rdb$relations + rdb$indices |
| USER_OBJECTS | rdb$relations + rdb$indices |
| USER_TAB_COLUMNS | rdb$relation_fields + rdb$fields |
| USER_TAB_COMMENTS | rdb$relations |
| USER_TABLES | rdb$relations |
| USER_TRIGGERS | rdb$relations + rdbvms$triggers |
| USER_VIEWS | rdb$view_relations |
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 Rdb system table are filled with zeros, spaces, null values, not-applicable values (N.A.), or default values, depending on the column type.
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 SQL*Plus 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.
Table C-2 ALL_CATALOG
| Name | Null? | Type | Value |
|---|---|---|---|
| OWNER | - | VARCHAR2(3) | "RDB" |
| TABLE_NAME | - | VARCHAR2(30) | - |
| TABLE_TYPE | - | VARCHAR2(5) | "TABLE" or "VIEW" |
Table C-3 ALL_COL_COMMENTS
| Name | Null? | Type | Value |
|---|---|---|---|
| OWNER | NOT NULL | CHAR(3) | "RDB" |
| TABLE_NAME | - | VARCHAR2(31) | - |
| COLUMN_NAME | - | VARCHAR2(31) | - |
| COMMENTS | NOT NULL | CHAR(1) | " " |
Table C-4 ALL_CONS_COLUMNS
| Name | Null? | Type | Value |
|---|---|---|---|
| OWNER | - | VARCHAR2(3) | "RDB" |
| CONSTRAINT_NAME | - | VARCHAR2(30) | - |
| TABLE_NAME | - | VARCHAR2(30) | - |
| COLUMN_NAME | - | VARCHAR2(4000) | - |
| POSITION | - | NUMBER | - |
Table C-5 ALL_CONSTRAINTS
| Name | Null? | Type | Value |
|---|---|---|---|
| OWNER | - | VARCHAR2(3) | "RDB" |
| CONSTRAINT_NAME | - | VARCHAR2(30) | - |
| CONSTRAINT_TYPE | - | VARCHAR2(1) | "R" or "P" or "U" |
| TABLE_NAME | - | VARCHAR2(30) | - |
| SEARCH_CONDITION | - | VARCHAR2(1) | " " |
| R_OWNER | - | VARCHAR2(3) | "RDB" |
| R_CONSTRAINT_NAME | - | VARCHAR2(30) | - |
| DELETE_RULE | - | VARCHAR2(1) | " " |
| STATUS | - | VARCHAR2(1) | " " |
| DEFERRABLE | - | VARCHAR2(1) | " " |
| DEFERRED | - | VARCHAR2(1) | " " |
| VALIDATED | - | VARCHAR2(1) | " " |
| GENERATED | - | VARCHAR2(1) | " " |
| BAD | - | VARCHAR2(1) | " " |
| RELY | - | VARCHAR2(1) | " " |
| LAST_CHANGE | - | VARCHAR2(0) | NULL |
Table C-6 ALL_IND_COLUMNS
| Name | Null? | Type | Value |
|---|---|---|---|
| INDEX_OWNER | NOT NULL | CHAR(3) | "RDB" |
| INDEX_NAME | - | VARCHAR2(31) | - |
| TABLE_OWNER | NOT NULL | CHAR(3) | "RDB" |
| TABLE_NAME | - | VARCHAR2 (31) | - |
| COLUMN_NAME | - | CHAR (31) | - |
| COLUMN_POSITION | - | NUMBER(10) | - |
| COLUMN_LENGTH | - | NUMBER (10) | - |
| DESCEND | NOT NULL | CHAR (1) | " " |
Table C-7 ALL_INDEXES
| Name | Null? | Type | Value |
|---|---|---|---|
| OWNER | - | VARCHAR2(3) | "RDB" |
| INDEX_NAME | - | VARCHAR2(30) | - |
| INDEX_TYPE | - | VARCHAR2 (1) | " " |
| TABLE_OWNER | - | VARCHAR2(3) | "RDB" |
| TABLE_NAME | - | VARCHAR2(30) | - |
| TABLE_TYPE | - | VARCHAR2 (5) | "TABLE" |
| UNIQUENESS | - | VARCHAR2(9) | "UNIQUE" or "NONUNIQUE" |
| COMPRESSION | - | VARCHAR2 (1) | " " |
| PREFIX_LENGTH | - | NUMBER | 0 |
| TABLESPACE_NAME | - | VARCHAR2 (14) | "RDB_TABLESPACE" |
| 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) | " " |
| 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 (5) | "VALID" |
| NUM_ROWS | - | NUMBER | 0 |
| SAMPLE_SIZE | - | NUMBER | 0 |
| LAST_ANALYZED | - | VARCHAR2(0) | NULL |
| DEGREE | - | VARCHAR2 (1) | " " |
| INSTANCES | - | VARCHAR2 (1) | " " |
| PARTITIONED | - | VARCHAR2 (1) | " " |
| TEMPORARY | - | VARCHAR2 (1) | " " |
| GENERATED | - | VARCHAR2 (1) | " " |
| SECONDARY | - | VARCHAR2 (1) | " " |
| BUFFER_POOL | - | VARCHAR2 (1) | " " |
| USER_STATS | - | VARCHAR2 (1) | " " |
| DURATION | - | VARCHAR2 (1) | " " |
| PCT_DIRECT_ACCESS | - | NUMBER | 0 |
| ITYP_OWNER | - | VARCHAR2 (1) | " " |
| ITYP_NAME | - | VARCHAR2 (1) | " " |
| PARAMETERS | - | VARCHAR2 (1) | " " |
| GLOBAL_STATS | - | VARCHAR2 (1) | " " |
| DOMIDX_STATUS | - | VARCHAR2 (1) | " " |
| DOMIDX_OPSTATUS | - | VARCHAR2 (1) | " " |
| FUNCIDX_STATUS | - | VARCHAR2 (1) | " " |
Table C-8 ALL_OBJECTS
| Name | Null? | Type | Value |
|---|---|---|---|
| OWNER | - | VARCHAR2(3) | "RDB" |
| OBJECT_NAME | - | VARCHAR2(30) | - |
| SUBOBJECT_NAME | - | VARCHAR2(1) | " " |
| OBJECT_ID | - | NUMBER | - |
| DATA_OBJECT_ID | - | NUMBER | 0 |
| OBJECT_TYPE | - | VARCHAR2(5) | "TABLE" or "VIEW" or "INDEX" |
| CREATED | - | VARCHAR2(0) |
|
| LAST_DDL_TIME | - | VARCHAR2(0) |
|
| TIMESTAMP | - | VARCHAR2(1) | " " |
| STATUS | - | VARCHAR2(5) | "VALID" |
| TEMPORARY | - | VARCHAR2(1) | " " |
| GENERATED | - | VARCHAR2(1) | " " |
| SECONDARY | - | VARCHAR2(1) | " " |
Table C-9 ALL_TAB_COLUMNS
| Name | Null? | Type | Value |
|---|---|---|---|
| OWNER | - | VARCHAR2(3) | "RDB" |
| TABLE_NAME | - | VARCHAR2(30) | - |
| COLUMN_NAME | - | VARCHAR2(30) | - |
| DATA_TYPE | - | VARCHAR2(8) | - |
| DATA_TYPE_MOD | - | VARCHAR2(1) | " " |
| DATA_TYPE_OWNER | - | VARCHAR2(1) | " " |
| 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) | " " |
| 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) | " " |
| CHAR_COL_DEC_LENGTH | - | NUMBER | 0 |
| GLOBAL_STATS | - | VARCHAR2(1) | " " |
| USER_STATS | - | VARCHAR2(1) | " " |
| AVG_COL_LEN | - | NUMBER | 0 |
Table C-10 ALL_TAB_COMMENTS
| Name | Null? | Type | Value |
|---|---|---|---|
| OWNER | - | VARCHAR2(3) | "RDB" |
| TABLE_NAME | - | VARCHAR2(30) | - |
| TABLE_TYPE | - | VARCHAR2(5) | "TABLE" or "VIEW" |
| COMMENTS | - | VARCHAR2 (1) | " " |
Table C-11 ALL_TABLES
| Name | Null? | Type | Value |
|---|---|---|---|
| OWNER | - | VARCHAR2(3) | "RDB" |
| TABLE_NAME | - | VARCHAR2(30) | - |
| TABLESPACE_NAME | - | VARCHAR2(14) | "RDB_TABLESPACE" |
| CLUSTER_NAME | - | VARCHAR2(1) | " " |
| IOT_NAME | - | VARCHAR2(1) | " " |
| 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) | " " |
| BACKED_UP | - | VARCHAR2(1) | " " |
| NUM_ROWS | - | NUMBER(19) | - |
| 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) | " " |
| INSTANCES | - | VARCHAR2(1) | " " |
| CACHE | - | VARCHAR2(1) | " " |
| TABLE_LOCK | - | VARCHAR2(1) | " " |
| SAMPLE_SIZE | - | NUMBER | 0 |
| LAST_ANALYZED | - | VARCHAR2(0) | " " |
| PARTITIONED | - | VARCHAR2(1) | " " |
| IOT_TYPE | - | VARCHAR2(1) | " " |
| TEMPORARY | - | VARHCAR2(1) | " " |
| SECONDARY | - | VARCHAR2(1) | " " |
| NESTED | - | VARCHAR2(1) | " " |
| BUFFER_POOL | - | VARCHAR2(1) | " " |
| ROW_MOVEMENT | - | VARCHAR2(1) | " " |
| GLOBAL_STATS | - | VARCHAR2(1) | " " |
| USER_STATS | - | VARCHAR2(1) | " " |
| DURATION | - | VARHCAR2(1) | " " |
| SKIP_CORRUPT | - | VARCHAR2(1) | " " |
| MONITORING | - | VARCHAR2(1) | " " |
Table C-12 ALL_TRIGGERS
| Name | Null? | Type | Value |
|---|---|---|---|
| OWNER | - | VARCHAR2(3) | "RDB" |
| TRIGGER_NAME | - | VARCHAR2(30) | - |
| TRIGGER_TYPE | - | VARCHAR2 (16) | "BEFORE STATEMENT" or "AFTER STATEMENT" |
| TRIGGERING_EVENT | - | VARCHAR2(1) | " " |
| TABLE_OWNER | - | VARCHAR2(3) | "RDB" |
| BASE_OBJECT_TYPE | - | VARCHAR2(1) | " " |
| TABLE_NAME | - | VARCHAR2(30) | " " |
| COLUMN_NAME | - | VARCHAR2(1) | " " |
| REFERENCING_NAMES | - | VARCHAR2(1) | " " |
| WHEN_CLAUSE | - | VARCHAR2(1) | " " |
| STATUS | - | VARCHAR2(7) | "ENABLED" |
| DESCRIPTION | - | VARCHAR2(1) | " " |
| ACTION_TYPE | - | VARCHAR2(1) | " " |
| TRIGGER_BODY | - | VARCHAR2(0) | "" |
Table C-13 ALL_USERS
| Name | Null? | Type | Value |
|---|---|---|---|
| USERNAME | NOT NULL | VARCHAR2(30) | "RDB" |
| USER_ID | - | NUMBER | 0 |
| CREATED | - | DATE | - |
Table C-14 ALL_VIEWS
| Name | Null? | Type | Value |
|---|---|---|---|
| OWNER | - | VARCHAR2(3) | "RDB" |
| VIEW_NAME | - | VARCHAR2(30) | - |
| TEXT_LENGTH | - | NUMBER | 0 |
| TEXT | - | VARCHAR2(1) | " " |
| TYPE_TEXT_LENGTH | - | NUMBER | 0 |
| TYPE_TEXT | - | VARCHAR2(1) | " " |
| OID_TEXT_LENGTH | - | NUMBER | 0 |
| OID_TEXT | - | VARCHAR2(1) | " " |
| VIEW_TYPE_OWNER | - | VARCHAR2(1) | " " |
| VIEW_TYPE | - | VARCHAR2(1) | " " |
Table C-15 DBA_CATALOG
| Name | Null? | Type | Value |
|---|---|---|---|
| OWNER | - | VARCHAR2(3) | "RDB" |
| TABLE_NAME | - | VARCHAR2(30) | - |
| TABLE_TYPE | - | VARCHAR2(5) | "TABLE" or "VIEW" |
Table C-16 DBA_COL_COMMENTS
| Name | Null? | Type | Value |
|---|---|---|---|
| OWNER | NOT NULL | CHAR(3) | "RDB" |
| TABLE_NAME | - | VARCHAR2(31) | - |
| COLUMN_NAME | - | VARCHAR2(31) | - |
| COMMENTS | NOT NULL | CHAR(1) | " " |
Table C-17 DBA_OBJECTS
| Name | Null? | Type | Value |
|---|---|---|---|
| OWNER | - | VARCHAR2(3) | "RDB" |
| OBJECT_NAME | - | VARCHAR2(31) | - |
| SUBOBJECT_NAME | - | VARCHAR2(1) | " " |
| OBJECT_ID | - | NUMBER | - |
| DATA_OBJECT_ID | - | NUMBER | 0 |
| OBJECT_TYPE | - | VARCHAR2(5) | "TABLE" or "VIEW" or "INDEX" |
| CREATED | - | VARCHAR2(0) | NULL |
| LAST_DDL_TIME | - | VARCHAR2(0) | NULL |
| TIMESTAMP | - | VARCHAR2(1) | " " |
| STATUS | - | VARCHAR2(5) | "VALID" |
| TEMPORARY | - | VARCHAR2(1) | " " |
| GENERATED | - | VARCHAR2(1) | " " |
| SECONDARY | - | VARCHAR2(1) | " " |
Table C-18 DBA_TAB_COLUMNS
| Name | Null? | Type | Value |
|---|---|---|---|
| OWNER | - | VARCHAR2(3) | "RDB" |
| TABLE_NAME | - | VARCHAR2(30) | - |
| COLUMN_NAME | - | VARCHAR2(30) | - |
| DATA_TYPE | - | VARCHAR2(8) | - |
| DATA_TYPE_MOD | - | VARCHAR2 (1) | " " |
| DATA_TYPE_OWNER | - | VARCHAR2 (1) | " " |
| DATA_LENGTH | - | NUMBER | - |
| DATA_PRECISION | - | NUMBER | - |
| DATA_SCALE | - | NUMBER | - |
| NULLABLE | - | VARCHAR2(1) | "Y" |
| COLUMN_ID | - | NUMBER | - |
| DEFAULT_LENGTH | - | NUMBER | 0 |
| DATA_DEFAULT | - | VARCHAR2 (1) | " " |
| 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) | " " |
| CHAR_COL_DEC_LENGTH | - | NUMBER | 0 |
| GLOBAL_STATS | - | VARCHAR2 (1) | " " |
| USER_STATS | - | VARCHAR2 (1) | " " |
| AVG_COL_LEN | - | NUMBER | 0 |
Table C-19 DBA_TAB_COMMENTS
| Name | Null? | Type | Value |
|---|---|---|---|
| OWNER | - | VARCHAR2(3) | "RDB" |
| TABLE_NAME | - | VARCHAR2(30) | - |
| TABLE_TYPE | - | VARCHAR2(5) | "TABLE" or "VIEW" |
| COMMENTS | - | VARCHAR2 (1) | " " |
Table C-20 DBA_TABLES
| Name | Null? | Type | Value |
|---|---|---|---|
| OWNER | - | VARCHAR2(3) | "RDB" |
| TABLE_NAME | - | VARCHAR2(30) | - |
| TABLESPACE_NAME | - | VARCHAR2 (14) | "RDB_TABLESPACE" |
| CLUSTER_NAME | - | VARCHAR2 (1) | " " |
| IOT_NAME | - | VARCHAR2 (1) | " " |
| 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) | " " |
| BACKED_UP | - | VARCHAR2(1) | " " |
| NUM_ROWS | - | NUMBER(19) | - |
| 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) | " " |
| INSTANCES | - | VARCHAR2(1) | " " |
| CACHE | - | VARCHAR2(1) | " " |
| TABLE_LOCK | - | VARCHAR2(1) | " " |
| SAMPLE_SIZE | - | NUMBER | 0 |
| LAST_ANALYZED | - | VARCHAR2(0) | NULL |
| PARTITIONED | - | VARCHAR2(1) | " " |
| IOT_TYPE | - | VARCHAR2(1) | " " |
| TEMPORARY | - | VARCHAR2(1) | " " |
| SECONDARY | - | VARCHAR2(1) | " " |
| NESTED | - | VARCHAR2(1) | " " |
| BUFFER_POOL | - | VARCHAR2(1) | " " |
| ROW_MOVEMENT | - | VARCHAR2(1) | " " |
| GLOBAL_STATS | - | VARCHAR2(1) | " " |
| USER_STATS | - | VARCHAR2(1) | " " |
| DURATION | - | VARCHAR2(1) | " " |
| SKIP_CORRUPT | - | VARCHAR2(1) | " " |
| MONITORING | - | VARCHAR2(1) | " " |
Table C-21 DICT_COLUMNS
| Name | Null? | Type | Value |
|---|---|---|---|
| TABLE_NAME | - | VARCHAR2(31) | - |
| COLUMN_NAME | - | VARCHAR2(31) | - |
| COMMENTS | NOT NULL | CHAR(1) | " " |
Table C-22 DICTIONARY
| Name | Null? | Type | Value |
|---|---|---|---|
| TABLE_NAME | - | VARCHAR2(31) | - |
| COMMENTS | NOT NULL | CHAR(1) | " " |
Table C-24 USER_CATALOG
| Name | Null? | Type | Value |
|---|---|---|---|
| TABLE_NAME | - | VARCHAR2(30) | - |
| TABLE_TYPE | - | VARCHAR2(5) | "TABLE" or "VIEW" |
Table C-25 USER_COL_COMMENTS
| Name | Null? | Type | Value |
|---|---|---|---|
| TABLE_NAME | - | VARCHAR2(31) | - |
| COLUMN_NAME | - | VARCHAR2(31) | - |
| COMMENTS | NOT NULL | CHAR(1) | " " |
Table C-26 USER_CONS_COLUMNS
| Name | Null? | Type | Value |
|---|---|---|---|
| OWNER | - | VARCHAR2(3) | "RDB" |
| CONSTRAINT_NAME | - | VARCHAR2(30) | - |
| TABLE_NAME | - | VARCHAR2(30) | - |
| COLUMN_NAME | - | VARCHAR2(4000) | - |
| POSITION | - | NUMBER | - |
Table C-27 USER_CONSTRAINTS
| Name | Null? | Type | Value |
|---|---|---|---|
| OWNER | - | VARCHAR2(3) | "RDB" |
| CONSTRAINT_NAME | - | VARCHAR2(30) | - |
| CONSTRAINT_TYPE | - | VARCHAR2(1) | "R" or "P" or "U" |
| TABLE_NAME | - | VARCHAR2(30) | - |
| SEARCH_CONDITION | - | VARCHAR2(1) | " " |
| R_OWNER | - | VARCHAR2(3) | "RDB" |
| R_CONSTRAINT_NAME | - | VARCHAR2(30) | - |
| DELETE_RULE | - | VARCHAR2(1) | " " |
| STATUS | - | VARCHAR2(1) | " " |
| DEFERRABLE | - | VARCHAR2(1) | " " |
| DEFERRED | - | VARCHAR2(1) | " " |
| VALIDATED | - | VARCHAR2(1) | " " |
| GENERATED | - | VARCHAR2(1) | " " |
| BAD | - | VARCHAR2(1) | " " |
| RELY | - | VARCHAR2(1) | " " |
| LAST_CHANGE | - | VARCHAR2(0) | NULL |
Table C-28 USER_INDEXES
| Name | Null? | Type | Value |
|---|---|---|---|
| INDEX_NAME | - | VARCHAR2(30) | - |
| INDEX_TYPE | - | VARCHAR2(1) | " " |
| TABLE_OWNER | - | VARCHAR2(3) | "RDB" |
| TABLE_NAME | - | VARCHAR2(30) | - |
| TABLE_TYPE | - | VARCHAR2(5) | "TABLE" |
| UNIQUENESS | - | VARCHAR2(9) | "UNIQUE" or "NONUNIQUE" |
| COMPRESSION | - | VARCHAR2(1) | NULL |
| PREFIX_LENGTH | - | NUMBER | 0 |
| TABLESPACE_NAME | - | VARCHAR2(14) | "RDB_TABLESPACE" |
| 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) | " " |
| 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(5) | "VALID" |
| NUM_ROWS | - | NUMBER | 0 |
| SAMPLE_SIZE | - | NUMBER | 0 |
| LAST_ANALYZED | - | VARCHAR2(0) | NULL |
| DEGREE | - | VARCHAR2(1) | " " |
| INSTANCES | - | VARCHAR2(1) | " " |
| PARTITIONED | - | VARCHAR2(1) | " " |
| TEMPORARY | - | VARCHAR2(1) | " " |
| GENERATED | - | VARCHAR2(1) | " " |
| SECONDARY | - | VARCHAR2(1) | " " |
| BUFFER_POOL | - | VARCHAR2(1) | " " |
| USER_STATS | - | VARCHAR2(1) | " " |
| DURATION | - | VARHCAR2(1) | " " |
| PCT_DIRECT_ACCESS | - | NUMBER | 0 |
| ITYP_OWNER | - | VARCHAR2(1) | " " |
| ITYP_NAME | - | VARCHAR2(1) | " " |
| PARAMETERS | - | VARCHAR2(1) | " " |
| GLOBAL_STATS | - | VARCHAR2(1) | " " |
| DOMIDX_STATUS | - | VARCHAR2(1) | " " |
| DOMIDX_OPSTATUS | - | VARCHAR2(1) | " " |
| FUNCIDX_STATUS | - | VARCHAR2(1) | " " |
Table C-29 USER_IND_COLUMNS
| Name | Null? | Type | Value |
|---|---|---|---|
| INDEX_NAME | - | VARCHAR2(31) | - |
| TABLE_NAME | - | VARCHAR2(31) | - |
| COLUMN_NAME | - | CHAR(31) | - |
| COLUMN_POSITION | - | NUMBER(10) | - |
| COLUMN_LENGTH | - | NUMBER(10) | - |
| DESCEND | NOT NULL | CHAR(1) | " " |
Table C-30 USER_OBJECTS
| Name | Null? | Type | Value |
|---|---|---|---|
| OBJECT_NAME | - | VARCHAR2(31) | - |
| SUBOBJECT_NAME | - | VARCHAR2(1) | " " |
| OBJECT_ID | - | NUMBER | - |
| DATA_OBJECT_ID | - | NUMBER | 0 |
| OBJECT_TYPE | - | VARCHR2(5) | "TABLE" or "VIEW" or "INDEX" |
| CREATED | - | VARCHR2(0) | - |
| LAST_DDL_TIME | - | VARCHAR2(0) | - |
| TIMESTAMP | - | VARCHAR2(1) | " " |
| STATUS | - | VARCHAR2(5) | "VALID |
| TEMPORARY | - | VARCHAR2(1) | " " |
| GENERATED | - | VARCHAR2(1) | " " |
| SECONDARY | - | VARCHAR2(1) | " " |
Table C-31 USER_TAB_COLUMNS
| Name | Null? | Type | Value |
|---|---|---|---|
| TABLE_NAME | - | VARCHAR2(30) | - |
| COLUMN_NAME | - | VARCHAR2(30) | - |
| DATA_TYPE | - | VARCHAR2(8) | - |
| DATA_TYPE_MOD | - | VARCHAR2(1) | " " |
| DATA_TYPE_OWNER | - | VARCHAR2(1) | " " |
| DATA_LENGTH | - | NUMBER | - |
| DATA_PRECISION | - | NUMBER | - |
| DATA_SCALE | - | NUMBER | - |
| NULLABLE | - | VARCHAR2(1) | "Y" |
| COLUMN_ID | - | NUMBER | - |
| DEFAULT_LENGTH | - | NUMBER | 0 |
| DATA_DEFAULT | - | VARCHAR2(1) | " " |
| 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) | " " |
| CHAR_COL_DECL_LENGTH | - | NUMBER | 0 |
| GLOBAL_STATS | - | VARCHAR2(1) | " " |
| USER_STATS | - | VARCHAR2(1) | " " |
| AVG_COL_LEN | - | NUMBER | 0 |
Table C-32 USER_TAB_COMMENTS
| Name | Null? | Type | Value |
|---|---|---|---|
| TABLE_NAME | - | VARCHAR2(30) | - |
| TABLE_TYPE | - | VARCHAR2(5) | "TABLE" or "VIEW" |
| COMMENTS | - | VARCHAR2(1) | " " |
Table C-33 USER_TABLES
| Name | Null? | Type | Value |
|---|---|---|---|
| TABLE_NAME | - | VARCHAR2(30) | - |
| TABLESPACE_NAME | - | VARCHAR2(14) | "RDB_TABLESPACE" |
| CLUSTER_NAME | - | VARCHAR2(1) | " " |
| IOT_NAME | - | VARCHAR2(1) | " " |
| 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) | " " |
| BACKED_UP | - | VARCHAR2(1) | " " |
| NUM_ROWS | - | NUMBER | - |
| 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) | " " |
| INSTANCES | - | VARCHAR2(1) | " " |
| CACHE | - | VARCHAR2(1) | " " |
| TABLE_LOCK | - | VARCHAR2(1) | " " |
| SAMPLE_SIZE | - | NUMBER | 0 |
| LAST_ANALYZED | - | VARCHAR2(0) | NULL |
| PARTITIONED | - | VARCHAR2(1) | " " |
| IOT_TYPE | - | VARCHAR2(1) | " " |
| TEMPORARY | - | VARCHAR2(1) | " " |
| SECONDARY | - | VARCHAR2(1) | " " |
| NESTED | - | VARCHAR2(1) | " " |
| BUFFER_POOL | - | VARCHAR2(1) | " " |
| ROW_MOVEMENT | - | VARCHAR2(1) | " " |
| GLOBAL_STATS | - | VARCHAR2(1) | " " |
| USER_STATS | - | VARCHAR2(1) | " " |
| DURATION | - | VARCHAR2(1) | " " |
| SKIP_CORRUPT | - | VARCHAR2(1) | " " |
| MONITORING | - | VARCHAR2(1) | " " |
Table C-34 USER_TRIGGERS
| Name | Null? | Type | Value |
|---|---|---|---|
| TRIGGER_NAME | - | VARCHAR2(30) | - |
| TRIGGER_TYPE | - | VARCHAR2 (16) | "BEFORE STATEMENT" or "AFTER STATEMENT" |
| TRIGGERING_EVENT | - | VARCHAR2(1) | " " |
| TABLE_OWNER | - | VARCHAR2(3) | "RDB" |
| BASE_OBJECT_TYPE | - | VARCHAR2(1) | " " |
| TABLE_NAME | - | VARCHAR2(30) | - |
| COLUMN_NAME | - | VARCHAR2(1) | " " |
| REFERENCING_NAMES | - | VARCHAR2(1) | " " |
| WHEN_CLAUSE | - | VARCHAR2(1) | " " |
| STATUS | - | VARCHAR2(7) | "ENABLED" |
| DESCRIPTION | - | VARCHAR2(1) | " " |
| ACTION_TYPE | - | VARCHAR2(1) | " " |
| TRIGGER_BODY | - | VARCHAR2(0) | " " |
Table C-35 USER_USERS
| Name | Null? | Type | Value |
|---|---|---|---|
| USERNAME | NOT NULL | VARCHAR2(30) | "RDB" |
| USER_ID | - | NUMBER | 0 |
| ACCOUNT_STATUS | - | VARCHAR2(4) | "OPEN" |
| LOCK_DATE | - | DATE | NULL |
| EXPIRY_DATE | - | DATE | NULL |
| DEFAULT_TABLESPACE | - | VARCHAR2(1) | " " |
| TEMPORARY_TABLESPACE | - | VARCHAR2(1) | " " |
| CREATED | - | DATE | - |
| INITIAL_RSRC_CONSUMER_GROUP | - | VARCHAR2(1) | " " |
| EXTERNAL_NAME | - | VARCHAR2(1) | " " |
