SQL*Plus
Configuration
Configuring SQL*Plus
2-7
@ORACLE_HOME\SQLPLUS\ADMIN\HELP\HLPBLD.SQL HELPUS.SQL
The HLPBLD.SQL script creates and loads the help tables.
Running the helpdrop.sql Script to Remove Command-line Help
Run the
provided SQL script, HELPDROP.SQL, to remove the command-line help.
1.
Log in to SQL*Plus as the SYSTEM user with:
SQLPLUS SYSTEM
You are prompted to enter the password you have defined for the SYSTEM user.
2.
In UNIX run the SQL script, HELPDROP.SQL, from SQL*Plus with:
@$ORACLE_HOME/SQLPLUS/ADMIN/HELP/HELPDROP.SQL
In Windows run the SQL script, HELPDROP.SQL, from SQL*Plus with:
@ORACLE_HOME\SQLPLUS\ADMIN\HELP\HELPDROP.SQL
The HELPDROP.SQL script
drops the help tables, and then disconnects.
Configuring Oracle Net Services
If you plan to connect to a database
other than the default, whether on the same
computer or another computer, you need to ensure that
Oracle Net is installed, and
the database listener is configured and running. Oracle Net services are used by
SQL*Plus.
Oracle Net services and the database listener are installed
by default during Oracle
Database installation. For further information about installing and configuring Oracle
Net, see the Oracle Database documentation at
http://www.oracle.com/technology/documentation
.