posted 22 years ago
This is from Oracle
If the HELP facility was initially loaded by the wrong user, you will
need to drop the table called "help" and re-install the help tables
as the oracle user.
To install HELP tables do the following:
1. Login as the oracle UNIX user
2. Set the environment variable SYSTEM_PASS to system/<the_system_passwd>
% setenv SYSTEM_PASS system/<manager>
Please note that the format for the set command is different for
Sequent Dynix.
3. For versions prior to 7.2, do the following to work
around bug-255977:
% cd $ORACLE_HOME/sqlplus/admin/help
% cp v7helptb.sql helptbl.sql
% cp v7plushp.ctl plushelp.ctl
4. Run the script "helpins"
% cd /tmp (or any directory where you have "write" permissions)
% $ORACLE_HOME/bin/helpins
HOW TO INSTALL THE HELP TABLES USING THE INSTALLER
Solution Description:
=====================
1. Set your ORACLE_SID to the database that is missing the
SQL*Plus help facility
2. Invoke the Installer:
% cd $ORACLE_HOME/orainst
% ./orainst
3. Answer the installer prompts as follows:
* Choose the 'Create new database objects' option
for all products
* Enter name of existing SID where you want to install
the help facility.
* Choose no products during the online documentation questions.
* At the 'Available Products' screen, choose only:
sqlplus -> install
* When prompted to:
"Select one of the following actions for ORACLE7 Server (RDBMS)",
choose:
Do Not Perform Any DB Actions
(you do not want to create any database objects as they are
already created)
* Would you like to load the SQL*Plus Help Facility?
choose:
YES
* Would you like to load the SQL*Plus Demo Tables?
choose:
YES
* Continue with the installation as you normally would.
3. When install is complete, invoke SQL*Plus; the help tables
should now be accessible
sqlplus scott/tiger
SQL -> help