C Data Dictionary
Data dictionary information is stored in the non-Oracle system as system tables and is accessed through ODBC application programming interfaces (APIs).
The following topics explain how to access non-Oracle data dictionaries, use supported views and tables, and data dictionary mapping:
Accessing the Non-Oracle Data Dictionary
Accessing a non-Oracle data dictionary table or view is identical to accessing a data dictionary in an Oracle database. You issue a SELECT
statement specifying a database link. The Oracle data dictionary view and column names are used to access the non-Oracle data dictionary. Synonyms of supported views are also acceptable.
For example, the following statement queries the data dictionary table ALL_USERS
to retrieve all users in the non-Oracle system:
SQL SELECT * FROM all_users@sid1;
When you issue a data dictionary access query, the ODBC agent:
Views and Tables Supported by Oracle Database Gateway for ODBC
Oracle Database Gateway for ODBC supports only the views and tables shown in the table, Oracle Database Gateway for ODBC Data Dictionary Mapping.
If you use an unsupported view, you receive an Oracle error message stating no rows were selected.
If you want to query data dictionary views using SELECT... FROM DBA_*
, first connect as Oracle user SYSTEM
or SYS
. Otherwise, you receive the following error message:
ORA-28506: Parse error in data dictionary translation for %s stored in %s
Using Oracle Database Gateway for ODBC, queries of the supported data dictionary tables and views beginning with the characters ALL_
may return rows from the non-Oracle system when you do not have access privileges for those non-Oracle objects. When querying an Oracle database with the Oracle data dictionary, rows are returned only for those objects you are permitted to access.
Data Dictionary Mapping
The tables in this section list Oracle data dictionary view names and the equivalent ODBC APIs used.
Table C-1 shows a list of all Oracle data dictionary view names supported by Oracle Database Gateway for ODBC.
Table C-1 Oracle Database Gateway for ODBC Data Dictionary Mapping
View | ODBC API |
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ALL_CATALOG
The Oracle Database Gateway for ODBC data dictionary tables and views provide the following information:
-
Name, data type, and width of each column
-
The contents of columns with fixed values
Table C-2 ALL_CATALOG
Name | Type | Value |
---|---|---|
|
|
- |
|
|
- |
|
|
|
ALL_COL_COMMENTS
The Oracle Database Gateway for ODBC data dictionary tables and views provide the following information:
-
Name, data type, and width of each column
-
The contents of columns with fixed values
Table C-3 ALL_COL_COMMENTS
Name | Type | Value |
---|---|---|
|
|
- |
|
|
- |
|
|
- |
|
|
|
ALL_CONS_COLUMNS
The Oracle Database Gateway for ODBC data dictionary tables and views provide the following information:
-
Name, data type, and width of each column
-
The contents of columns with fixed values
Table C-4 ALL_CONS_COLUMNS
Name | Type | Value |
---|---|---|
|
|
- |
|
|
- |
|
|
- |
|
|
- |
|
|
- |
ALL_CONSTRAINTS
The Oracle Database Gateway for ODBC data dictionary tables and views provide the following information:
-
Name, data type, and width of each column
-
The contents of columns with fixed values
Table C-5 ALL_CONSTRAINTS
Name | Type | Value |
---|---|---|
|
|
- |
|
|
- |
|
|
|
|
|
- |
|
|
|
|
|
- |
|
|
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ALL_IND_COLUMNS
The Oracle Database Gateway for ODBC data dictionary tables and views provide the following information:
-
Name, data type, and width of each column
-
The contents of columns with fixed values
Table C-6 ALL_IND_COLUMNS
Name | Type | Value |
---|---|---|
|
|
- |
|
|
- |
|
|
- |
|
|
- |
|
|
- |
|
|
- |
|
|
- |
|
|
|
ALL_INDEXES
The Oracle Database Gateway for ODBC data dictionary tables and views provide the following information:
-
Name, data type, and width of each column
-
The contents of columns with fixed values
Table C-7 ALL_INDEXES
Name | Type | Value |
---|---|---|
|
|
- |
|
|
- |
|
|
|
|
|
- |
|
|
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ALL_OBJECTS
The Oracle Database Gateway for ODBC data dictionary tables and views provide the following information:
-
Name, data type, and width of each column
-
The contents of columns with fixed values
Table C-8 ALL_OBJECTS
Name | Type | Value |
---|---|---|
|
|
- |
|
|
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ALL_TAB_COLUMNS
The Oracle Database Gateway for ODBC data dictionary tables and views provide the following information:
-
Name, data type, and width of each column
-
The contents of columns with fixed values
Table C-9 ALL_TAB_COLUMNS
Name | Type | Value |
---|---|---|
|
|
- |
|
|
- |
|
|
- |
|
|
- |
|
|
|
|
|
|
|
|
- |
|
|
- |
|
|
- |
|
|
|
|
|
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ALL_TAB_COMMENTS
The Oracle Database Gateway for ODBC data dictionary tables and views provide the following information:
-
Name, data type, and width of each column
-
The contents of columns with fixed values
Table C-10 ALL_TAB_COMMENTS
Name | Type | Value |
---|---|---|
|
|
- |
|
|
- |
|
|
|
|
|
|
ALL_TABLES
The Oracle Database Gateway for ODBC data dictionary tables and views provide the following information:
-
Name, data type, and width of each column
-
The contents of columns with fixed values
Table C-11 ALL_TABLES
Name | Type | Value |
---|---|---|
|
|
- |
|
|
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
|
|
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ALL_USERS
The Oracle Database Gateway for ODBC data dictionary tables and views provide the following information:
-
Name, data type, and width of each column
-
The contents of columns with fixed values
Table C-12 ALL_USERS
Name | Type | Value |
---|---|---|
|
|
- |
|
|
|
|
|
|
ALL_VIEWS
The Oracle Database Gateway for ODBC data dictionary tables and views provide the following information:
-
Name, data type, and width of each column
-
The contents of columns with fixed values
Table C-13 ALL_VIEWS
Name | Type | Value |
---|---|---|
|
|
- |
|
|
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
DICTIONARY
The Oracle Database Gateway for ODBC data dictionary tables and views provide the following information:
-
Name, data type, and width of each column
-
The contents of columns with fixed values
Table C-14 DICTIONARY
Name | Type | Value |
---|---|---|
|
|
- |
|
|
|
DICT_COLUMNS
The Oracle Database Gateway for ODBC data dictionary tables and views provide the following information:
-
Name, data type, and width of each column
-
The contents of columns with fixed values
Table C-15 DICT_COLUMNS
Name | Type | Value |
---|---|---|
|
|
- |
|
|
- |
|
|
|
USER_CATALOG
The Oracle Database Gateway for ODBC data dictionary tables and views provide the following information:
-
Name, data type, and width of each column
-
The contents of columns with fixed values
Table C-16 USER_CATALOG
Name | Type | Value |
---|---|---|
|
|
- |
|
|
|
USER_COL_COMMENTS
The Oracle Database Gateway for ODBC data dictionary tables and views provide the following information:
-
Name, data type, and width of each column
-
The contents of columns with fixed values
Table C-17 USER_COL_COMMENTS
Name | Type | Value |
---|---|---|
|
|
- |
|
|
- |
|
|
|
USER_CONS_COLUMNS
The Oracle Database Gateway for ODBC data dictionary tables and views provide the following information:
-
Name, data type, and width of each column
-
The contents of columns with fixed values
Table C-18 USER_CONS_COLUMNS
Name | Type | Value |
---|---|---|
|
|
- |
|
|
- |
|
|
- |
|
|
- |
|
|
- |
USER_CONSTRAINTS
The Oracle Database Gateway for ODBC data dictionary tables and views provide the following information:
-
Name, data type, and width of each column
-
The contents of columns with fixed values
Table C-19 USER_CONSTRAINTS
Name | Type | Value |
---|---|---|
|
|
- |
|
|
- |
|
|
|
|
|
- |
|
|
|
|
|
- |
|
|
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
USER_IND_COLUMNS
The Oracle Database Gateway for ODBC data dictionary tables and views provide the following information:
-
Name, data type, and width of each column
-
The contents of columns with fixed values
Table C-20 USER_IND_COLUMNS
Name | Type | Value |
---|---|---|
|
|
- |
|
|
- |
|
|
|
|
|
|
|
|
|
|
|
|
USER_INDEXES
The Oracle Database Gateway for ODBC data dictionary tables and views provide the following information:
-
Name, data type, and width of each column
-
The contents of columns with fixed values
Table C-21 USER_INDEXES
Name | Type | Value |
---|---|---|
|
|
|
|
|
|
|
|
- |
|
|
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
USER_OBJECTS
The Oracle Database Gateway for ODBC data dictionary tables and views provide the following information:
-
Name, data type, and width of each column
-
The contents of columns with fixed values
Table C-22 USER_OBJECTS
Name | Type | Value |
---|---|---|
|
|
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
USER_TABCOLUMNS
The Oracle Database Gateway for ODBC data dictionary tables and views provide the following information:
-
Name, data type, and width of each column
-
The contents of columns with fixed values
Table C-23 USER_TABCOLUMNS
Name | Type | Value |
---|---|---|
|
|
- |
|
|
- |
|
|
- |
|
|
|
|
|
|
|
|
- |
|
|
- |
|
|
- |
|
|
|
|
|
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
USER_TAB_COMMENTS
The Oracle Database Gateway for ODBC data dictionary tables and views provide the following information:
-
Name, data type, and width of each column
-
The contents of columns with fixed values
Table C-24 USER_TAB_COMMENTS
Name | Type | Value |
---|---|---|
|
|
- |
|
|
|
|
|
|
USER_TABLES
The Oracle Database Gateway for ODBC data dictionary tables and views provide the following information:
-
Name, data type, and width of each column
-
The contents of columns with fixed values
Table C-25 USER_TABLES
Name | Type | Value |
---|---|---|
|
|
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- |
|
|
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
USER_USERS
The Oracle Database Gateway for ODBC data dictionary tables and views provide the following information:
-
Name, data type, and width of each column
-
The contents of columns with fixed values
Table C-26 USER_USERS
Name | Type | Value |
---|---|---|
|
|
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
USER_VIEWS
The Oracle Database Gateway for ODBC data dictionary tables and views provide the following information:
-
Name, data type, and width of each column
-
The contents of columns with fixed values
Table C-27 USER_VIEWS
Name | Type | Value |
---|---|---|
|
|
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|