C Data Dictionary
The Oracle Database Gateway for Sybase translates a query that refers to an Oracle database data dictionary table into a query that retrieves the data from Sybase system 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. The gateway data dictionary is similar to the Oracle database data dictionary in appearance and use.
- Sybase System Tables
Sybase data dictionary information is stored in the Sybase database as Sybase system 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. - 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. - Supported Views and Tables
The Oracle Database Gateway for Sybase supports views and tables. - Data Dictionary Mapping
The tables in this section list Oracle data dictionary view names and the equivalent Sybase system tables. - Gateway Data Dictionary Descriptions
This topic provides descriptions of the Oracle Database Gateway for Sybase data dictionaries. - ALL_CATALOG
ALL_CATALOG
data dictionary for Oracle Database Gateway for Sybase. - ALL_COL_COMMENTS
ALL_COL_COMMENTS
data dictionary for Oracle Database Gateway for Sybase. - ALL_CONS_COLUMNS
ALL_CONS_COLUMNS
data dictionary for Oracle Database Gateway for Sybase. - ALL_CONSTRAINTS
ALL_CONSTRAINTS
data dictionary for Oracle Database Gateway for Sybase. - ALL_IND_COLUMNS
ALL_IND_COLUMNS
data dictionary for Oracle Database Gateway for Sybase. - ALL_INDEXES
ALL_INDEXES
data dictionary for Oracle Database Gateway for Sybase. - ALL_OBJECTS
ALL_OBJECTS
data dictionary for Oracle Database Gateway for Sybase. - ALL_TAB_COLUMNS
ALL_TAB_COLUMNS
data dictionary for Oracle Database Gateway for Sybase. - ALL_TAB_COMMENTS
ALL_TAB_COMMENTS
data dictionary for Oracle Database Gateway for Sybase. - ALL_TABLES
ALL_TABLES
data dictionary for Oracle Database Gateway for Sybase. - ALL_USERS
ALL_USERS
data dictionary for Oracle Database Gateway for Sybase. - ALL_VIEWS
ALL_VIEWS
data dictionary for Oracle Database Gateway for Sybase. - DBA_CATALOG
DBA_CATALOG
data dictionary for Oracle Database Gateway for Sybase. - DBA_COL_COMMENTS
DBA_COL_COMMENTS
data dictionary for Oracle Database Gateway for Sybase. - DBA_OBJECTS
DBA_OBJECTS
data dictionary for Oracle Database Gateway for Sybase. - DBA_TAB_COLUMNS
DBA_TAB_COLUMNS
data dictionary for Oracle Database Gateway for Sybase. - DBA_TAB_COMMENTS
DBA_TAB_COMMENTS
data dictionary for Oracle Database Gateway for Sybase. - DBA_TABLES
DBA_TABLES
data dictionary for Oracle Database Gateway for Sybase. - DICT_COLUMNS
DICT_COLUMNS
data dictionary for Oracle Database Gateway for Sybase. - DICTIONARY
DICTIONARY
data dictionary for Oracle Database Gateway for Sybase. - DUAL
DUAL
data dictionary for Oracle Database Gateway for Sybase. - TABLE_PRIVILEGES
TABLE_PRIVILEGES
data dictionary for Oracle Database Gateway for Sybase. - USER_CATALOG
USER_CATALOG
data dictionary for Oracle Database Gateway for Sybase. - USER_COL_COMMENTS
USER_COL_COMMENTS
data dictionary for Oracle Database Gateway for Sybase. - USER_CONS_COLUMNS
USER_CONS_COLUMNS
data dictionary for Oracle Database Gateway for Sybase. - USER_CONSTRAINTS
USER_CONSTRAINTS
data dictionary for Oracle Database Gateway for Sybase. - USER_IND_COLUMNS
USER_IND_COLUMNS
data dictionary for Oracle Database Gateway for Sybase. - USER_INDEXES
USER_INDEXES
data dictionary for Oracle Database Gateway for Sybase. - USER_OBJECTS
USER_OBJECTS
data dictionary for Oracle Database Gateway for Sybase. - USER_TAB_COLUMNS
USER_TAB_COLUMNS
data dictionary for Oracle Database Gateway for Sybase. - USER_TAB_COMMENTS
USER_TAB_COMMENTS
data dictionary for Oracle Database Gateway for Sybase. - USER_TABLES
USER_TABLES
data dictionary for Oracle Database Gateway for Sybase. - USER_USERS
USER_USERS
data dictionary for Oracle Database Gateway for Sybase. - USER_VIEWS
USER_VIEWS
data dictionary for Oracle Database Gateway for Sybase.