A
Customizing Operating System Parameters

This chapter describes how to customize your SQL*Plus configuration by changing parameters in the registry.

Specific topics discussed are:

• Using the Registry
• Parameter Descriptions

 

Warning:   Only advanced users should change the registry.

   

Using the Registry

When you install Oracle products for Windows NT or Windows 95/98, Oracle Installer adds relevant parameters to the registry. You can examine these parameters by running one of the following programs:

• REGEDT32.EXE (under Windows NT)
• REGEDIT.EXE (under Windows 95/98)

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

See the registry's online help 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.

Parameter Descriptions

This section describes the registry parameters that are relevant to SQL*Plus for Windows NT/95 (the parameters reside in HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\).

PLUS80

Default Value: ORACLE_HOME\PLUS80

Valid Values: any directory on any drive

This parameter specifies the location of the SQL*Plus files, including the GLOGIN.SQL file. In addition to searching the directory specified by PLUS80, SQL*Plus also searches the current directory for SQL*Plus files.

The first four characters of this parameter, PLUS, refer to SQL*Plus. The remaining characters correspond to the current version of SQL*Plus. Subsequent versions of SQL*Plus may use a different version number (for example, PLUS81) to enable you to keep multiple versions of SQL*Plus on your computer.

PLUS_DFLT

Default Value: PLUS80

Valid Values: any SQL*Plus executable, such as PLUS80 or PLUS80W

This parameter specifies the SQL*Plus executable to be spawned when SQLPLUS.EXE is started.

SQLPATH

Default Value: ORACLE_HOME\DBS

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.

Note:   SQL*Plus uses the PLUS80 parameter to specify the location of the GLOGIN.SQL script. Refer to "PLUS80" earlier in this appendix for more information.

   

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

C:\ORANT\DATA;C:\ORANT\DBS

---