Oracle SQL*Plus - What Are SQL*Plus Environment Variables
Interview Question Database For Software Developers
|
|
| What Are SQL*Plus Environment Variables | | What Are SQL*Plus Environment Variables? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool | | By: FYIcenter.com | Behaviors of SQL*Plus are also controlled a some environment variables predefined on the
local operating system. Here are some commonly used SQL*Plus environment variables:
- ORACLE_HOME - The home directory where your Oracle client application is installed.
- PATH - A list of directories where SQL*Plus will search for executable or DLL files.
PATH should include $ORACLE_HOME\bin.
- SQLPLUS - The directory where localization messages are stored.
SQLPLUS should be set to $ORACLE_HOME\sqlplus\mesg
- TNS_ADMIN - The directory where the connect identifier file, tnsnames.ora is located.
TNS_ADMIN should be set to $ORACLE_HOME/network/admin.
| | ID: 598 | Rank: 1120 | Votes: 0 | Views: 80 | Submitted: 20070429 |
Copyright © 2009 FYIcenter.com
All rights in the contents of this Website are reserved by the individual author.
No part of the contents may be reproduced in any form without author's permission.
|
|
|
Atom feed
List view