Install the Sqlplus help command line script in the ORACLE database under $oracle_home/sqlplus/admin/help.
As shown below:
[Email protected] admin]$ CD $ORACLE _home/sqlplus/admin
[Email protected] admin]$ ls-ltr
Total 20
-rw-r--r--1 Oracle Oinstall 2118 FEB 2003 Pupbld.sql
-rw-r--r--1 Oracle Oinstall 813 Mar 7 2006 Plustrce.sql
-rw-r--r--1 Oracle oinstall 368 APR glogin.sql
-rw-r--r--1 Oracle Oinstall 226 libsqlplus.def
Drwxr-xr-x 2 Oracle Oinstall 4096 02:39 Help
[Email protected] admin]$ CD Help
[Email protected] help]$ ls-ltr
Total 84
-rw-r--r--1 Oracle Oinstall 265 FEB 2003 Helpbld.sql
-rw-r--r--1 Oracle Oinstall 2154 Jan 3 hlpbld.sql
-rw-r--r--1 Oracle Oinstall 366 Jan 3 Helpdrop.sql
-rw-r--r--1 Oracle Oinstall 71817-Helpus.sql
[Email protected] help]$ pwd
/u01/app/db11g/product/11.2.0/dbhome_1/sqlplus/admin/help
[Email protected] help]$
Helpus.sql---->>> is called by Helpbld.sql, is the Help content to insert text into Sqlplus
Helpdrop.sql---->>>, as the name implies, is to delete the Help table, but to execute the script as a system user
Hlpbld. SQL---->>>to Drop and create new help tables.
The installation steps are as follows:
1. Log in to Sql*plus as the SYSTEM user with:
SQLPLUS SYSTEM
2. In UNIX run the SQL script, Hlpbld. SQL, from Sql*plus with:
@ $ORACLE _home/sqlplus/admin/help/hlpbld. SQL Helpus. Sql
In Windows run the SQL script, Hlpbld. SQL, from Sql*plus with:
@ORACLE_HOME \sqlplus\admin\help\hlpbld. SQL Helpus. Sql
The hlpbld. SQL script creates and loads the help tables.
The drop is simpler, it's all official documents, just do it.
----------->>> This chapter has nothing to chew on the bones, can be a wink.
