User`s guide

9030971 E17
8-1
Chapter 8
Oracle Exports
Provides information about Oracle export requirements and considerations.
Configuring the dtxscript File
To export to Oracle tables, you must configure the dtxscript file, which is
located in the .../Spectrum/SG-Tools directory.
Modify the script’s “Necessary Oracle additions” section as follows:
The ORACLE_HOME variable must be uncommented (remove the #
character). Add the complete path of the Oracle root directory to the right
of the = sign.
On UNIX platforms only, the ORACLE_SID variable must be
uncommented. Add the name of the Oracle server to the right of the =
sign. The Oracle server name (also called the Oracle System Identifier) is
normally four alphanumeric characters.
The export ORACLE_HOME and export ORACLE_SID commands must be
uncommented.
The PATH variable must be uncommented.
The export PATH command must be uncommented.
The CONNECTSTRING variable must be uncommented. Add the database
name or database alias to the right of the = sign.
On the NT platform only, the ORAPLUS_VER variable must be
uncommented. Add the version number of Oracle SQL*Plus to the right of
the = sign. Only the first two digits are required, and they must be
enclosed in quotes. For example, the variable line for SQL*Plus version
number 3.1.3.5.4 should read ORAPLUS_VER=Ò3.1Ó.