Using the Registry

When you install Oracle products for Windows, Oracle Universal Installer adds relevant parameters to the registry.

The following table indicates which registry version(s)--REGEDT32.EXE and/or REGEDIT.EXE--you can use for your particular Windows platform:

Windows Platform	REGEDT32.EXE	REGEDIT.EXE
Windows NT 4.0	YES	YES
Windows 95	NO	YES
Windows 98	NO	YES

The HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE subkey contains the Oracle parameters.

See the registry's help system for instructions on how to edit the parameters.

If you change the value of an Oracle parameter or add a parameter to the registry, the change will take effect whenever SQL*Plus executes a procedure that uses the parameter.

SQLPATH Parameter Description

This section describes the SQLPATH registry parameter used by SQL*Plus for Windows.

Subkey: HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0

Default Value: \ORACLE\ORA81

Valid Values: any directory on any drive

This parameter specifies the location of SQL scripts. In addition to searching the directory specified by the SQLPATH parameter, SQL*Plus also searches the current directory for SQL scripts.

When you set the SQLPATH parameter, directories can be concatenated with a semicolon (;). For example:

C:\ORACLE\ORA81\DATABASE;C:\ORACLE\ORA81\DBS