DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: help installing SQLPlus help

  1. #1
    Join Date
    Feb 2002
    Posts
    4

    Unhappy help installing SQLPlus Help

    Hi.
    I'm trying to install SQLPlus help but when I run the helpbld.sql script I get these prompts ("Enter value for 1:" and "Enter value for datafile:") I have no idea what they are. Can anyone help me please?
    Thanks.

    ___________________________________________
    SQL> @oracle/ora81/sqlplus/admin/help/helpbld.sql

    Enter value for 1:

    SP2-0137: DEFINE requires a value following equal sign
    Table dropped.
    Table created.
    Grant succeeded.

    Enter value for datafile:





    [Edited by heloisa on 02-17-2002 at 06:41 PM]
    Heloisa

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Look at the header of the file. You should see something like this:
    Code:
    --
    -- Copyright (c) 1983, 1998 by Oracle Corporation. All Rights Reserved.
    --
    -- NAME
    --   helpbld.sql
    --
    -- DESCRIPTION
    --   Builds the SQL*Plus HELP table and loads the HELP data from a
    --   data file.  The datafile must exist before this script is run.
    --
    -- NOTES
    --   To run this script, connect as SYSTEM and pass the datafile to be
    --   loaded as a parameter e.g.
    --
    --       sqlplus system/ @helpbld.sql helpus.sql
    --
    --
    Jeff Hunter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width