Re: Help in sqlplus

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Wed, 7 Jun 2000 14:38:28 -0400
Message-Id: <10521.108099@fatcity.com>

Thanks to all the replied. My AIX boxes do not have the helpins.txt file but I managed to run SQL*Loader and get it to work. Thanks to everyone who replied.

Regards,
Ruth
----- Original Message -----
From: Jonathan Gennick <jonathan_at_gennick.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Wednesday, June 07, 2000 1:38 PM
Subject: Re: Help in sqlplus

On Wed, 07 Jun 2000 08:31:02 -0800, Ruth Gramolini wrote:

>How do you create the help tables on the server and client for SQL*PLUS. I
>know that this is a simple question but I am a simple person.

I'm running 8.1.5, and I have a directory named $ORACLE_HOME/sqlplus/admin/help. In that directory are the files needed to load the help table used by SQL*PLus. My Windows NT system contains file named helpinst.txt that contains instructions for using SQL*Loader to load the help data. On my Linux box I don't have the helpinst.txt file, just the plushelp.ctl file used to load the help table. I believe that you need to log in as SYSTEM, run helptbl.sql, then helpindx.sql, and then use SQL*Loader to load the actual data from plushelp.ctl.

Beginning with release 8.1, the SQL*Plus help table no longer contains help for PL/SQL and SQL statements. It now only documents SQL*Plus commands.

regards,

Jonathan

jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are

--
Author: Jonathan Gennick
  INET: jonathan_at_gennick.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed Jun 07 2000 - 13:38:28 CDT