如何给sqlplus 安装help
[size=12px]Installing the Help Facility ManuallyThe Help Facility may be installed manually using the shell script
$ORACLE_HOME/bin/helpins. Before you run the script, the SYSTEM_PASS environment variable should be set to the SYSTEM schema name and password. For example:
$ setenv SYSTEM_PASS SYSTEM/MANAGER
$ helpins
If the SYSTEM_PASS variable is not set, helpins prompts you for the SYSTEM password and loads the help data into the SYSTEM schema. You can also run $ORACLE_HOME/sqlplus/help/helpbld.sql helpus.sql to install the Help Facility. The system user can run the file helpbld.sql and its argument, helpus.sql, in SQL*Plus to create Help Facility Tables. For example:
$ sqlplus system/manager
SQL> @?/sqlplus/admin/help/helpbld.sql helpus.sql[/size] 使用时键入help index显示帮助项，然后寻找相应的帮助
SQL> help index
@ COPY PAUSE SHUTDOWN
@@ DEFINE PRINT SPOOL
/ DEL PROMPT SQLPLUS
ACCEPT DESCRIBE QUIT START
APPEND DISCONNECT RECOVER STARTUP
ARCHIVE LOG EDIT REMARK STORE
ATTRIBUTE EXECUTE REPFOOTER TIMING
BREAK EXIT REPHEADER TTITLE
BTITLE GET RESERVED WORDS (SQL) UNDEFINE
CHANGE HELP RESERVED WORDS (PL/SQL) VARIABLE
CLEAR HOST RUN WHENEVER OSERROR
COLUMN INPUT SAVE WHENEVER SQLERROR
COMPUTE LIST SET
CONNECT PASSWORD SHOW
SQL> help copy
COPY
----
COPY copies data from a query to a table in a local or remote
database.
COPY {FROM database | TO database | FROM database TO database}
{APPEND|CREATE|INSERT|REPLACE} destination_table
[(column, column, column, ...)] USING query
where database has the following syntax:
username[/password]@connect_identifier SQL> help create user
CREATE USER
-----------
Use CREATE USER to create a database user, or an account through
which you can log in to the database, and establish the means by
which Oracle permits access by the user. You can optionally
assign the following properties to the user:
* default tablespace
* temporary tablespace
* quotas for allocating space in tablespaces
* profile containing resource limits
CREATE USER user IDENTIFIED {BY password | EXTERNALLY | GLOBALLY AS 'CN=user'}
[ DEFAULT TABLESPACE tablespace
| TEMPORARY TABLESPACE tablespace
| QUOTA { integer [K | M] | UNLIMITED } ON tablespace
[ QUOTA { integer [K | M] | UNLIMITED } ON tablespace ] ...
| PROFILE profile
| PASSWORD EXPIRE
| ACCOUNT { LOCK | UNLOCK } ... ]
For detailed information on this command, see the Oracle8 Server SQL
Reference.
附件中的sql已经转换成insert语句啦，大家直接用system运行@help.sql
就可以安装超级帮助。 太感谢了 那不是省了很多
页:
[1]