B
Data Dictionary

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

Sybase System Tables

Sybase data dictionary information is stored in the Sybase database as Sybase system tables. All Sybase system tables have names prefaced with "sys". The Sybase system tables define the structure of a database. When you change data definitions, Sybase reads and modifies the Sybase 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 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 Sybase database:

SQL> SELECT * FROM "ALL_TABLES"@SYBS;

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

Maps the requested table, view, or synonym to one or more Sybase system table names. The gateway translates all data dictionary column names to their corresponding Sybase column names within the query. If the mapping involves one Sybase system table, the gateway translates the requested table name to its corresponding Sybase system table name within the query. If the mapping involves multiple Sybase system tables, the gateway constructs a join in the query using the translated Sybase system table names.
Sends the translated query to Sybase.
Might convert the retrieved Sybase data to give it the appearance of the Oracle database server data dictionary table.
Passes the data dictionary information from the translated Sybase 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 Sybase Tables

Queries issued directly to individual Sybase system tables are allowed but they return different results because the Sybase system table column names differ from those of the data dictionary view. Also, certain columns in a Sybase 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_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 the supported data dictionary tables and views beginning with the characters ALL_ might return rows from the Sybase database when you do not have access privileges for those Sybase 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 Sybase System tables used. A plus sign (+) indicates that a join operation is involved.

Table B-2 Oracle Data Dictionary View Names and Sybase Equivalents

View Name	Sybase System Table Name
ALL_CATALOG	sysusers + sysobjects
ALL_COL_COMMENTS	sysusers+sysobjects+syscolumns
ALL_CONS_COLUMNS	sp_pkeys + sp_fkeys
ALL_CONSTRAINTS	sp_pkeys + sp_fkeys
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	sp_pkeys + sp_fkeys
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 Sybase 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.

Table B-3 ALL_CATALOG

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

Table B-4 ALL_COMMENTS

Name	Null?	Type
OWNER	NOT NULL	VARCHAR2(30)
TABLE_NAME	NOT NULL	VARCHAR2(30)
COLUMN_NAME	NOT NULL	VARCHAR2(30)
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	Type	Value
OWNER	VARCHAR2(30)
CONSTRAINT_NAME	VARCHAR2(30)
CONSTRAINT_TYPE	VARCHAR2(1)	"R" or "P"
TABLE_NAME	VARCHAR2(30)
SEARCH_CONDITION	VARCHAR2(1)	NULL
R_OWNER	VARCHAR2(30)
R_CONSTRAINT_NAME	VARCHAR2(30)
DELETE_RULE	VARCHAR2(9)	"CASCADE" or "NO ACTION" or "SET 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-7 ALL_INDEXES

Name	Null?	Type	Value
OWNER	NOT NULL	VARCHAR2(30)
INDEX_NAME		VARCHAR2(30)
INDEX_TYPE		VARCHAR2(1)	NULL
TABLE_OWNER	NOT NULL	VARCHAR2(30)
TABLE_NAME	NOT NULL	VARCHAR2(30)
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	Type	Value
OWNER	VARCHAR2(30)
OBJECT_NAME	VARCHAR2(30)
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	Type	Value
OWNER	VARCHAR2(30)
TABLE_NAME	VARCHAR2(30)
COLUMN_NAME	VARCHAR2(30)
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)	NULL
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(30)
TABLE_NAME	NOT NULL	VARCHAR2(30)
TABLE_TYPE		VARCHAR2(5)	"TABLE" or "VIEW"
COMMENTS		VARCHAR2(1)	NULL

Table B-11 ALL_TABLES

Name	Null?	Type	Value
OWNER	NOT NULL	VARCHAR2(30)
TABLE_NAME	NOT NULL	VARCHAR2(30)
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(30)
USER_ID	NOT NULL	NUMBER(5)
CREATED		VARCHAR2(0)	NULL

Table B-13 ALL_VIEWS

Name	Null?	Type	Value
OWNER	NOT NULL	CHAR(30)
VIEW_NAME	NOT NULL	CHAR(30)
TEXT_LENGTH	NOT NULL	NUMBER(10)	0
TEXT	NOT NULL	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(30)
TABLE_NAME	NOT NULL	VARCHAR2(30)
TABLE_TYPE		VARCHAR2(5)	"TABLE" or "VIEW"

Table B-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)	NULL

Table B-16 DBA_OBJECTS

Name	Type	Value
OWNER	VARCHAR2(30)
OBJECT_NAME	VARCHAR2(30)
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	Type	Value
OWNER	VARCHAR2(30)
TABLE_NAME	VARCHAR2(30)
COLUMN_NAME	VARCHAR2(30)
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)	NULL
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(30)
TABLE_NAME	NOT NULL	VARCHAR2(30)
TABLE_TYPE		VARCHAR2(5)	"TABLE" or "VIEW"
COMMENTS		VARCHAR2(1)	NULL

Table B-19 DBA_TABLES

Name	Null?	Type	Value
OWNER	NOT NULL	VARCHAR2(30)
TABLE_NAME	NOT NULL	VARCHAR2(30)
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(30)
COLUMN_NAME	NOT NULL	VARCHAR2(30)
COMMENTS	NOT NULL	CHAR2(1)	NULL

Table B-21 DICTIONARY

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

Table B-22 DUAL

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

Table B-23 TABLE_PRIVILEGES

Name	Null?	Type	Value
GRANTEE	NOT NULL	VARCHAR2(30)
OWNER	NOT NULL	VARCHAR2(30)
TABLE_NAME	NOT NULL	VARCHAR2(30)
GRANTOR	NOT NULL	VARCHAR2(30)
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(30)
TABLE_TYPE		VARCHAR2(5)	"TABLE" or "VIEW"

Table B-25 USER_COL_COMMENTS

Name	Null?	Type	Value
TABLE_NAME	NOT NULL	VARCHAR2(30)
COLUMN_NAME	NOT NULL	VARCHAR2(30)
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	Type	Value
OWNER	VARCHAR2(30)
CONSTRAINT_NAME	VARCHAR2(30)
CONSTRAINT_TYPE	VARCHAR2(1)	"R" or "P"
TABLE_NAME	VARCHAR2(30)
SEARCH_CONDITION	VARCHAR2(1)	NULL
R_OWNER	VARCHAR2(30)
R_CONSTRAINT_NAME	VARCHAR2(30)
DELETE_RULE	VARCHAR2(9)	"CASCADE" or "NOACTION" or "SET 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(30)
INDEX_TYPE		VARCHAR2(1)	NULL
TABLE_OWNER	NOT NULL	VARCHAR2(30)
TABLE_NAME	NOT NULL	VARCHAR2(30)
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	Type	Value
OBJECT_NAME	VARCHAR2(30)
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	Type	Value
TABLE_NAME	VARCHAR2(30)
COLUMN_NAME	VARCHAR2(30)
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(30)
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(30)
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(30)
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(30)
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

BData Dictionary