How To Configure $SQLPATH In Windows

REGISTRY ENTRY

  • Use regedit.exe to update the HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\Key_<oracle_home_name>\SQLPATH with the required full path location of the $SQLPATH directory. e.g. C:\DBA.
    • The default setting for $SQLPATH is $ORACLE_HOME\dbs.

AUTOMATIC ENVIRONMENT SET UP

  • SQL*Plus will look for the login.sql file in either the current directory, or the directory set up in $SQLPATH.
© copyright 2001-2014 ABCdba.com | all rights reserved