Pre-Installation Requirements

You need to have the correct software installed and know how to issue the SQL GRANT command in order to install the adapter.

Software Requirements

Before you install the adapter, please review the following list of software requirements:

Oracle must be installed and working. If it is not, contact your Oracle database administrator. The adapter may be used with any version of Oracle supported by Oracle.
FOCUS must be installed on your system. If it is not, contact your FOCUS database administrator or consult your FOCUS installation guide for instructions on installing FOCUS.
You also need to know your FOCUS release and Service Pack level. Every time you invoke FOCUS, the banner displays the release.
Your FOCUS and Oracle maintenance must be up to date.
The Adapter for Oracle is installed as read/write. Therefore, the adapter can both read and update tables and views.

Native SQL Requirement

GRANT is a native SQL command that authorizes users to access Oracle tables. As a run-time requirement, this command must be issued after the adapter is installed.

You need to know the command syntax and have authorization for the tables or views and plans or modules in question. If you are unfamiliar with the GRANT command, contact your Oracle database administrator for assistance.

Note: Additional privileges may be required to use two adapter features, FOCUS CREATE FILE and ON TABLE HOLD FORMAT SQLORA, which dynamically create Oracle tables with indices.