Overview | Environments | Databases | Tables | Queries | Updates | Stored Procedures | Example

The Omnidex Environment File contains metadata that describes the Oracle database and the Omnidex configuration. This includes the following Oracle information:

• Oracle major version number (eg. 10, 11, etc)
• Connection information, such as a user and password
• SQL*Net service information
• Oracle schema information tables, columns and datatypes
• Oracle primary and foreign key constraints
• Oracle native indexes

Either document OAHELPER or EXTRACT DDL using this syntax:

EXTRACT   DDL 
    FROM    <ORACLE | SQLSERVER | MYSQL | OBDC>
    TO      filename
    WITH    options
  
  options:

  VERSION = ' '
  SUBTYPE = ' '
  USERNAME = ' '
  PASSWORD = ' '
  SERVICE = ' '
  TABLES = ' '
  INDEX_DIRECTORY = ' '
  DATABASE = ' '

Prev | Next

See also: