在某DB上想查看sqlplus的'set'命令用法:
SQL> ? set
SP2-0171: HELP system not available.
Cause
Command-line SQL*Plus help is not installed in this Oracle instance.
Action
Command-line SQL*Plus help is not installed in this Oracle instance. Use the $ORACLE_HOME/sqlplus/admin/help/hlpbld.sql script to install HELP on this database:
SQL> @?/sqlplus/admin/help/hlpbld.sql helpus.sql
在刚才的命令中如果不输入'helpus.sql',则需要交互式的回答以下两个问题:
--输入helpbld.sql所在目录的全路径
var1 :
/opt/oracle/product/11.2.0/sqlplus/admin/help
--输入helpus.sql文件的全路径(包含文件名)
var2 :
/opt/oracle/product/11.2.0/sqlplus/admin/help/helpus.sql