Oracle 1 0g extended Help File Installation

Oracle's online help system is implemented through the ystem. help table, which stores SQL information in Oracle.

First, use the system user to log on to sqlplus, oracle Training

Run select count (1) from system. help;

There are only over 900 things, too few. Here you have installed more than 900 things, but there are too few things here. You have not installed the extended help system, and there is too little help here.

1. Execute the following statement to delete the following two tables and recreate them:

Drop table help;

CREATE TABLE HELP

(

TOPIC VARCHAR2 (50) not null,

Seq number not null,

INFO VARCHAR2 (80)

) PCTFREE 0 STORAGE (INITIAL 48 k pctincrease 0 );

Grant select on help to public;

ALTER TABLE HELP

Add constraint HELP_TOPIC_SEQ

Primary key (TOPIC, SEQ)

Using index storage (INITIAL 10 K );

Drop view HELP_TEMP_VIEW;

Create view HELP_TEMP_VIEW (TOPIC)

Select distinct upper (TOPIC)

From help;

INSERT INTO HELP

SELECT 'topics ', ROWNUM + 10, TOPIC

FROM HELP_TEMP_VIEW;

COMMIT;

Drop view HELP_TEMP_VIEW;

2. Download the Oracle Help File statement:

Free in http://linux.bkjia.com/

The username and password are both www.bkjia.com

The specific download directory is available for installation in the/June/OCTOBER/Oracle1 0g extended help file.

For the download method, see

Execute the content of these two files under the system user.

3. Run help sqlplus to view the content of sqlplus.