HELP! sqlplus help doesn't install

From: Denis Beauchemin <Denis.Beauchemin_at_Courrier.USherb.ca>
Date: Thu, 28 Sep 2000 19:02:10 GMT
Message-ID: <SAMA5.3$8n3.35@carnaval.risq.qc.ca>

Hello,

I run into problems installing sqlplus help tables. Could anyone help me get the help online? 8-)

NOTE: I changed the sqlldr bndsize (from 512000) in helpins because it would stop earlier on. I also get no ".bad" files. Password changed for obvious reasons:

[oracle oracle]$ ORACLE_TRACE=T LOG=helpins.log ORACLE_SID=gis SYSTEM_PASS=system/Secretpw helpins
++ HELPDIR=/oracle01/app/oracle/product/8.1.5/sqlplus/admin/help

+++ pwd

++ CDIR=/home/oracle
++ sqlplus system/Secretpw

SQL*Plus: Release 8.1.5.0.0 - Production on Thu Sep 28 14:40:52 2000

Connected to:
Oracle8i Release 8.1.5.0.0 - Production
With the Java option
PL/SQL Release 8.1.5.0.0 - Production

SQL> Disconnected from Oracle8i Release 8.1.5.0.0 - Production With the Java option
PL/SQL Release 8.1.5.0.0 - Production
++ cd /oracle01/app/oracle/product/8.1.5/sqlplus/admin/help
++ SQLLOAD=sqlldr
++ sqlldr userid=system/Secretpw control=plushelp.ctl
log=/home/oracle/plusload.log bad=/home/oracle/plusload.bad rows=1024 bindsize=65535

SQL*Loader: Release 8.1.5.0.0 - Production on Thu Sep 28 14:41:02 2000

Commit point reached - logical record count 84
Commit point reached - logical record count 168
Commit point reached - logical record count 252
Commit point reached - logical record count 336
Commit point reached - logical record count 420
Commit point reached - logical record count 504
Commit point reached - logical record count 588
Commit point reached - logical record count 672
Commit point reached - logical record count 756
Commit point reached - logical record count 840
Commit point reached - logical record count 886

++ cd /home/oracle
++ sqlplus system/Secretpw

SQL*Plus: Release 8.1.5.0.0 - Production on Thu Sep 28 14:41:04 2000

Connected to:
Oracle8i Release 8.1.5.0.0 - Production
With the Java option
PL/SQL Release 8.1.5.0.0 - Production

SQL> Disconnected from Oracle8i Release 8.1.5.0.0 - Production With the Java option
PL/SQL Release 8.1.5.0.0 - Production
[oracle oracle]$ ORACLE_SID=gis sqlplus system/Secretpw

SQL*Plus: Release 8.1.5.0.0 - Production on Thu Sep 28 14:41:37 2000

Connected to:
Oracle8i Release 8.1.5.0.0 - Production
With the Java option
PL/SQL Release 8.1.5.0.0 - Production

SQL> help create
SP2-0172: No HELP available.
SQL> quit
Disconnected from Oracle8i Release 8.1.5.0.0 - Production With the Java option
PL/SQL Release 8.1.5.0.0 - Production
[oracle oracle]$

Contents of helpindx.lis file:

Table altered.

1 row created.

View created.

57 rows created.

View dropped.

Contents of helptbl.lis file:

Table created.

Grant succeeded.

Contents of plusload.log file:
SQL*Loader: Release 8.1.5.0.0 - Production on Thu Sep 28 14:41:02 2000

Control File: plushelp.ctl

Data File:      plushelp.ctl
  Bad File:     /home/oracle/plusload.bad

Discard File: none specified

(Allow all discards)

Number to load: ALL
Number to skip: 0
Errors allowed: 50
Bind array:     1024 rows, maximum of 65535 bytes
Continuation:    none specified
Path used:      Conventional

Table HELP, loaded from every logical record. Insert option in effect for this table: APPEND TRAILING NULLCOLS option in effect

   Column Name                  Position   Len  Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ------------------
---
TOPIC                               FIRST     *   ^       CHARACTER
SEQ                                  NEXT     *   ^       CHARACTER
INFO                                 NEXT     *   ^       CHARACTER

Table HELP:
  886 Rows successfully loaded.
  0 Rows not loaded due to data errors.
  0 Rows not loaded because all WHEN clauses were failed.   0 Rows not loaded because all fields were null.

Space allocated for bind array:                  65016 bytes(84 rows)
Space allocated for memory besides bind array:        0 bytes

Total logical records skipped:          0
Total logical records read:           886
Total logical records rejected:         0
Total logical records discarded:        0

Run began on Thu Sep 28 14:41:02 2000
Run ended on Thu Sep 28 14:41:04 2000

Elapsed time was:     00:00:02.23
CPU time was:         00:00:00.12

Thanks!

Denis Beauchemin, Analyste
Service des Technologies de l'Information Université de Sherbrooke
T: 819.821.8000.2252 F: 819.821.8045 Received on Thu Sep 28 2000 - 14:02:10 CDT