User`s guide

9030971 E17 Oracle Exports
8-3
Installation Considerations
After you run Data Export, the spectrum user ID owns the newly created
tables. Your database administrator should use the Oracle grant command to
allow access to the tables.
Data Export uses the Oracle SQL*Loader utility to load database tables.
Refer to your Oracle documentation for other restrictions and
recommendations about the SQL*Loader utility.
You should be aware of any restrictions imposed by the Oracle Database
Management System, such as reserved words and naming conventions. See
the appropriate Oracle manuals for information.
Installation Considerations
In order to perform Oracle exports:
• SpectroGRAPH must be installed on the Oracle Server machine. This is
because SQL*Loader is currently bundled with the Oracle Server
software. (This restriction may be removed in the future if Oracle
licensing and bundling policies change.)
• The direct path connection between the Oracle Server and the Oracle
Client must be homogeneous.
• If you are exporting over SQL-Net, the two machines involved must be
running the same hardware and operating system platforms to use Direct
Load. If the two machines are not homogeneous, Conventional Load
should be used.