wood burning stoves 2.0*
The moose likes Oracle/OAS and the fly likes How to set HELP command active in SQL*Plus Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "How to set HELP command active in SQL*Plus" Watch "How to set HELP command active in SQL*Plus" New topic

How to set HELP command active in SQL*Plus

nan sh
Ranch Hand

Joined: Jan 05, 2001
Posts: 167
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 ]

Have you tried this Mock Exam Testing Engine yet?<br /><a href="http://www.mycgiserver.com/~nan111/index.html" target="_blank" rel="nofollow">www.mycgiserver.com/~nan111/index.html</a>
Beksy Kurian
Ranch Hand

Joined: Jul 11, 2001
Posts: 254
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
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)",

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?


* Would you like to load the SQL*Plus Demo Tables?


* 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

Joined: Jan 05, 2001
Posts: 167
Thanks Beksy, even though I use w2k, it's help a lots.
I agree. Here's the link: http://aspose.com/file-tools
subject: How to set HELP command active in SQL*Plus
Similar Threads
How to issue command in Java program
Oracle describe table from jdbc
executing scripts
Processing None-SQL query via JDBC
How do I start using PL/SQL