• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

How to set HELP command active in SQL*Plus

 
Ranch Hand
Posts: 167
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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 ]
 
Ranch Hand
Posts: 254
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks Beksy, even though I use w2k, it's help a lots.
 
reply
    Bookmark Topic Watch Topic
  • New Topic