Q
Problem solve Get help with specific problems with your technologies, process and projects.

No SQL*Plus help available

After successfully installing the Oracle Enterprise Version (7.3.3) on the SCO-Unix platform, no SQL*Plus help was available (e.g. alter table command, create table command syntax). What is the remedy?

The SQL*Plus Help facitily is not installed by default. You will have to install it manually. You can do that by performing the following operations:

  1. Go to the help directory:
         
       % cd $ORACLE_HOME/sqlplus/admin/help 
     
  2. Login to SQL*Plus as the user SYSTEM. (Make sure your environment is set up correctly first.)
       % sqlplus system/<password> 
     
  3. Run the helptbl.sql script.
       SQL> @helptbl 
     
  4. Use SQL*Loader to populate the Help tables:
       % sqlldr system/manager control=plushelp.ctl 
       % sqlldr system/manager control=sqlhelp.ctl 
       % sqlldr system/manager control=plshelp.ctl 
     
  5. Log back into SQL*Plus as the user SYSTEM and run the "helpindx.sql" script.
       SQL> @helpindx 
    

For More Information


Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close