This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
integration:rdbms:oracle:environments [2011/04/01 21:12] doc |
integration:rdbms:oracle:environments [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 11: | Line 11: | ||
| [[integration:rdbms:oracle:databases|Databases]] | | [[integration:rdbms:oracle:databases|Databases]] | | ||
| [[integration:rdbms:oracle:tables|Tables]] | | [[integration:rdbms:oracle:tables|Tables]] | | ||
| - | [[integration:rdbms:oracle:indexes|Indexes]] | | + | [[integration:rdbms:oracle:constraints|Constraints]] | |
| + | [[integration:rdbms:oracle:datatypes|Datatypes]] | | ||
| [[integration:rdbms:oracle:queries|Queries]] | | [[integration:rdbms:oracle:queries|Queries]] | | ||
| [[integration:rdbms:oracle:updates|Updates]] | | [[integration:rdbms:oracle:updates|Updates]] | | ||
| Line 31: | Line 32: | ||
| === Generating an Omnidex Environment File === | === Generating an Omnidex Environment File === | ||
| - | Omnidex can automatically generate the CREATE ENVIRONMENT, CREATE DATABASE, CREATE TABLE and CREATE INDEX statements needed for an Omnidex Environment File. The [[dev:sql:statements:extract|EXTRACT]] statement is used to connect to the Oracle database, query the underlying schema information, and generate the appropriate statements. | + | Omnidex can automatically generate the CREATE ENVIRONMENT, CREATE DATABASE, CREATE TABLE and CREATE INDEX statements needed for an Omnidex Environment File. The [[dev:sql:statements:extract:home|EXTRACT]] statement is used to connect to the Oracle database, query the underlying schema information, and generate the appropriate statements. This statement can be issued through OdxSQL, or through any ODBC or JDBC application. |
| <code> | <code> | ||
| Line 38: | Line 39: | ||
| to "simple.sql" | to "simple.sql" | ||
| with VERSION="11" | with VERSION="11" | ||
| - | USERNAME="simple" | + | USER="simple" |
| PASSWORD="simple" | PASSWORD="simple" | ||
| + | DATABASE="simple" | ||
| INDEX_DIRECTORY="idx" | INDEX_DIRECTORY="idx" | ||
| </code> | </code> | ||
| \\ | \\ | ||
| - | The following options can be used on the EXTRACT statement to provide Oracle connection information and control the output of the statement: | + | The following options from the [[dev:sql:statements:extract:home|EXTRACT]] SQL statement are used to provide Oracle connection information and control the output of the statement. These options also correlate with the options of the [[dev:sql:statements:create_database:home|CREATE DATABASE]] statement. |
| == VERSION == | == VERSION == | ||
| Line 49: | Line 51: | ||
| The major version of Oracle. Currently, Oracle versions "10" and "11" are supported. This option is required. | The major version of Oracle. Currently, Oracle versions "10" and "11" are supported. This option is required. | ||
| - | == USERNAME == | + | == USER == |
| - | The username to be used when accessing Oracle. One username and password is used when connecting to the Oracle database. That login determines that security access to the database and the visibility of the underlying database objects. This option is required. | + | The user to be used when accessing Oracle. One user and password is used when connecting to the Oracle database. That login determines that security access to the database and the visibility of the underlying database objects. This option is required. |
| == PASSWORD == | == PASSWORD == | ||
| - | The password to be used when accessing Oracle. This password must correspond to the username referenced in the USERNAME option. This option is required. | + | The password to be used when accessing Oracle. This password must correspond to the user referenced in the USER option. This option is required. |
| == SERVICE == | == SERVICE == | ||
| Line 81: | Line 83: | ||
| * Oracle National Character datatypes, which are commonly used to store Unicode data, are shown as CHARACTER or STRING datatype, as these are the most universal datatypes in an Omnidex application. If necessary, these can be changed to Omnidex NCHARACTER or NSTRING datatypes. | * Oracle National Character datatypes, which are commonly used to store Unicode data, are shown as CHARACTER or STRING datatype, as these are the most universal datatypes in an Omnidex application. If necessary, these can be changed to Omnidex NCHARACTER or NSTRING datatypes. | ||
| * Depending on the configuration of the Oracle database, some constraint information may not be available and must be added manually. | * Depending on the configuration of the Oracle database, some constraint information may not be available and must be added manually. | ||
| + | |||
| + | === Manually Creating an Omnidex Environment File === | ||
| + | |||
| + | An Omnidex Environment File can also be created by manually issuing CREATE ENVIRONMENT, CREATE DATABASE, CREATE TABLE and CREATE INDEX statements in OdxSQL or using ODBC or JDBC. If these statements are written to a text batch file, then that file can be submitted to OdxSQL using the USE command. | ||
| + | |||
| ===== ===== | ===== ===== | ||