C.3 Gateway Data Dictionary Descriptions

These topics describe the data dictionaries for Oracle Database Gateway for SQL Server.

The gateway data dictionary tables and views provide the following information:

• Name, data type, and width of each column
• The contents of columns with fixed values

They are described here with information retrieved by an Oracle SQL*Plus DESCRIBE command. The values in the Null? column might differ from the Oracle database data dictionary tables and views. Any default value is shown to the right of an item, but this is not information returned by DESCRIBE.

Note:

The column width of some columns in the translated data dictionary tables would be different when the gateway connects to a SQL Server Version 7.0 database.