ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-01919

ORA-01919

原创 Linux操作系统 作者:fei890910 时间:2013-11-19 19:33:58 0 删除 编辑
SQL> set autotrace trace 
SP2-0618: Cannot find the Session Identifier.  Check PLUSTRACE role is enabled
SP2-0611: Error enabling STATISTICS report
SQL> conn / as sysdba
SQL> grant PLUSTRACE to hr;
grant PLUSTRACE to hr
      *
ERROR at line 1:
ORA-01919: role 'PLUSTRACE' does not exist

SQL> @/u01/app/oracle/product/11.2.0/db_1/sqlplus/admin/plustrce.sql
SQL> 
SQL> drop role plustrace;
drop role plustrace
          *
ERROR at line 1:
ORA-01919: role 'PLUSTRACE' does not exist
SQL> create role plustrace;
Role created.
SQL> 
SQL> grant select on v_$sesstat to plustrace;
rant succeeded.
SQL> grant select on v_$statname to plustrace;
Grant succeeded.
SQL> grant select on v_$mystat to plustrace;
Grant succeeded.
SQL> grant plustrace to dba with admin option;
Grant succeeded.
SQL> 
SQL> set echo off
SQL> @/u01/app/oracle/product/11.2.0/db_1/rdbms/admin/utlxplan.sql 
Table created.

SQL> grant PLUSTRACE to hr;

Grant succeeded.













来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29108064/viewspace-777023/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 删除undo表空间
请登录后发表评论 登录
全部评论

注册时间:2013-08-15

  • 博文量
    120
  • 访问量
    746487