ORA-01039 SP2-0612

ORA-01039 SP2-0612 的处理
conn /as sysdba
@?/sqlplus/admin/plustrce.sql
grant plustrace to test;
grant select any dictionary to test;

select privilege from dba_sys_privs where grantee='SH'

union

select privilege from dba_sys_privs where grantee in (select granted_role from dba_role_privs where grantee='SH' );

[@more@]

EXPLAIN PLAN

1 使用utlxplan.sql创建plan_table表
2 创建解释计划
Explain plan for
select last_name from hr.employees;
3 查询plan_table
直接查询
使用脚本utlxpls.sql查询
使用脚本utlxplp.sql查询

原来9i中的一些资料

SQL> set autotrace on
SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled
SP2-0611: Error enabling STATISTICS report

SQL> conn system/oracle@orcl_10.10.10.26
Connected.
SQL> @D:oracleora92rdbmsadminutlxplan.sql
SQL> create public synonym plan_table for plan_table;
SQL> grant all on plan_table to public;
SQL> conn sys/oracle@orcl_10.10.10.26 as sysdba
Connected.
SQL> @D:oracleora92sqlplusadminplustrce.sql

SQL> grant plustrace to public;

Grant succeeded.

SQL>

SQL> conn scott/tiger@orcl
Connected.
SQL> set autotrace on statistics

end

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

转载于:http://blog.itpub.net/271063/viewspace-1056537/