C Data Dictionary

The Oracle Database Gateway for SQL Server translates a query that refers to an Oracle database data dictionary table into a query that retrieves the data from SQL Server 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.

• Data Dictionary Support
  The following topics describe the Oracle Database Gateway for SQL Server data dictionary support.
• Data Dictionary Mapping
  The tables in this section list Oracle data dictionary view names and the equivalent SQL Server system tables used.
• Gateway Data Dictionary Descriptions
  These topics describe the data dictionaries for Oracle Database Gateway for SQL Server.
• ALL_CATALOG
  ALL_CATALOG data dictionary for Oracle Database Gateway for SQL Server.
• ALL_COL_COMMENTS
  ALL_COL_COMMENTS data dictionary for Oracle Database Gateway for SQL Server.
• ALL_CONS_COLUMNS
  ALL_CONS_COLUMNS data dictionary for Oracle Database Gateway for SQL Server.
• ALL_CONSTRAINTS
  ALL_CONSTRAINTS data dictionary for Oracle Database Gateway for SQL Server.
• ALL_IND_COLUMNS
  ALL_IND_COLUMNS data dictionary for Oracle Database Gateway for SQL Server.
• ALL_INDEXES
  ALL_INDEXES data dictionary for Oracle Database Gateway for SQL Server.
• ALL_OBJECTS
  ALL_OBJECTS data dictionary for Oracle Database Gateway for SQL Server.
• ALL_TAB_COLUMNS
  ALL_TAB_COLUMNS data dictionary for Oracle Database Gateway for SQL Server.
• ALL_TAB_COMMENTS
  ALL_TAB_COMMENTS data dictionary for Oracle Database Gateway for SQL Server.
• ALL_TABLES
  ALL_TABLES data dictionary for Oracle Database Gateway for SQL Server.
• ALL_USERS
  ALL_USERS data dictionary for Oracle Database Gateway for SQL Server.
• ALL_VIEWS
  ALL_VIEWS data dictionary for Oracle Database Gateway for SQL Server.
• DBA_CATALOG
  DBA_CATALOG data dictionary for Oracle Database Gateway for SQL Server.
• DBA_COL_COMMENTS
  DBA_COL_COMMENTS data dictionary for Oracle Database Gateway for SQL Server.
• DBA_OBJECTS
  DBA_OBJECTS data dictionary for Oracle Database Gateway for SQL Server.
• DBA_TAB_COLUMNS
  DBA_TAB_COLUMNS data dictionary for Oracle Database Gateway for SQL Server.
• DBA_TAB_COMMENTS
  DBA_TAB_COMMENTS data dictionary for Oracle Database Gateway for SQL Server.
• DBA_TABLES
  DBA_TABLES data dictionary for Oracle Database Gateway for SQL Server.
• DICT_COLUMNS
  DICT_COLUMNS data dictionary for Oracle Database Gateway for SQL Server.
• DICTIONARY
  DICTIONARY data dictionary for Oracle Database Gateway for SQL Server.
• DUAL
  DUAL data dictionary for Oracle Database Gateway for SQL Server.
• TABLE_PRIVILEGES
  TABLE_PRIVILEGES data dictionary for Oracle Database Gateway for SQL Server.
• USER_CATALOG
  USER_CATALOG data dictionary for Oracle Database Gateway for SQL Server.
• USER_COL_COMMENTS
  USER_COL_COMMENTS data dictionary for Oracle Database Gateway for SQL Server.
• USER_CONS_COLUMNS
  USER_CONS_COLUMNS data dictionary for Oracle Database Gateway for SQL Server.
• USER_CONSTRAINTS
  USER_CONSTRAINTS data dictionary for Oracle Database Gateway for SQL Server.
• USER_IND_COLUMNS
  USER_IND_COLUMNS data dictionary for Oracle Database Gateway for SQL Server.
• USER_INDEXES
  USER_INDEXES data dictionary for Oracle Database Gateway for SQL Server.
• USER_OBJECTS
  USER_OBJECTS data dictionary for Oracle Database Gateway for SQL Server.
• USER_TAB_COLUMNS
  USER_TAB_COLUMNS data dictionary for Oracle Database Gateway for SQL Server.
• USER_TAB_COMMENTS
  USER_TAB_COMMENTS data dictionary for Oracle Database Gateway for SQL Server.
• USER_TABLES
  USER_TABLES data dictionary for Oracle Database Gateway for SQL Server.
• USER_USERS
  USER_USERS data dictionary for Oracle Database Gateway for SQL Server.
• USER_VIEWS
  USER_VIEWS data dictionary for Oracle Database Gateway for SQL Server.