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.