Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to set HELP command active in SQL*Plus

 
nan sh
Ranch Hand
Posts: 167
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
HI all,
Anyone can help me for that?
Under Oracle SQL*Plus, if I enter HELP , it respond as "SP2-0171: HELP not accessible.".
How can I set HELP command in active?
[ February 02, 2002: Message edited by: nan sh ]
 
Beksy Kurian
Ranch Hand
Posts: 254
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
nan sh
Ranch Hand
Posts: 167
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Beksy, even though I use w2k, it's help a lots.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic