怎运行呀? SQL> GRANT EXECUTE ON dbms_shared_pool TO uwclass; GRANT EXECUTE ON dbms_shared_pool TO uwclass * 第 1 行出现错误: ORA-04042: 过程, 函数, 程序包或程序包体不存在 SQL> EXECUTE ON dbms_shared_pool TO uwclass; BEGIN ON dbms_shared_pool TO uwclass; END; * 第 1 行出现错误: ORA-06550: 第 1 行, 第 7 列: PLS-00103: 出现符号 "ON"在需要下列之一时: begin case declare exit for goto if loop mod null pragma raise return select update while with <an identifier> <a double-quoted delimited-identifier> <a bind variable> << close current delete fetch lock insert open rollback savepoint set sql execute commit forall merge pipe
你还没有安装dbmspool.sql脚本,你需要先安装dbmspool.sql脚本。 具体方法如下: 1. sqlplus中在作为SYS用户登录: sqlplus "/ as sysdba" 2.在sqlplus中运行下面命令行: @?/rdbms/admin/dbmspool.sql
dbmspool.sql通常在 $ORACLE_HOME/rdbms/admin/中
SQL> GRANT EXECUTE ON dbms_shared_pool TO uwclass;
GRANT EXECUTE ON dbms_shared_pool TO uwclass
*
第 1 行出现错误:
ORA-04042: 过程, 函数, 程序包或程序包体不存在
SQL> EXECUTE ON dbms_shared_pool TO uwclass;
BEGIN ON dbms_shared_pool TO uwclass; END; *
第 1 行出现错误:
ORA-06550: 第 1 行, 第 7 列:
PLS-00103: 出现符号 "ON"在需要下列之一时:
begin case declare exit for
goto if loop mod null pragma raise return select update while
with <an identifier> <a double-quoted delimited-identifier>
<a bind variable> << close current delete fetch lock insert
open rollback savepoint set sql execute commit forall merge
pipe
具体方法如下:
1. sqlplus中在作为SYS用户登录:
sqlplus "/ as sysdba"
2.在sqlplus中运行下面命令行:
@?/rdbms/admin/dbmspool.sql
大哥,我按照你的方法进去,进不了呀,闪一下就关闭了