1.ORA-942解决
问题：在执行set autotrace traceonly报错误，如下：
SQL> show user;
USER is "HXL"
SQL> set autotrace traceonly;
Error ORA-942 while gathering statistics
SP2-0611: Error enabling STATISTICS report
解决办法：
执行：SQL> @D:\oracle\product\11.2.0\dbhome_1\sqlplus\admin\plustrce.sql
Grant PLUSTRACE to HXL;
阅读(3055) | 评论(0) | 转发(0) |
