SQL Navigator for Oracle 7.5 - User Guide

Server side installation

Server-side configuration is not required for general operation of SQL Navigator. It is required for operation of the Explain Plan Tool. The PL/SQL Profiler and Java->PL/SQL Publisher requires server-side support, which is installed on demand.

You can invoke the Server-Side Installation Wizard from the Tools menu. The wizard requires connection as a DBA user so that the SQLNAV user can be created, as well as a number of roles. The wizard permits you to specify a password of your choice for this user. Note that the option "Base SQLNAV Repository" must be selected on at least one occasion to allow the other support features to be installed. All objects installed by the wizard are installed into the SQLNAV schema.

To install support for Explain Plan

To save SQL statements in the Explain Plan tool, a special table is required in the SQLNAV schema.

Follow these steps:

1. Start SQL Navigator.
2. Click Tools | Server-Side Installation Wizard.
3. Select Install Server-Side Objects | Next.
4. Ensure that "Base SQLNAV Repository" and "Explain Plan Support" are selected. Click Next.
5. Enter a username (DBA user, such as SYS), password and connection. Click Connect.
6. Choose a tablespace for the objects to be created in the SQLNAV schema. Click Next.
7. Enter a password for the SQLNAV user. Enter it again in the confirmation box. Click Next.
8. Perform one of the following:
   • Click Install | Next.
   • As a DBA user, run the script CRTUSER.SQL located in the install folder under the SQL Navigator installation folder (C:\Program Files\Quest Software\SQL Navigator for Oracle by default) to create the SQLNAV schema.
9. As user SQLNAV, run the script CRTSQLTB.SQL to create the Saved SQL's table.