看这里~
http://www.itpub.net/139409.html
1、sys用户
SQL> alter system set QUERY_REWRITE_INTEGRITY=TRUSTED scope=both;System altered.SQL> show parameter QUERY_REWRITE_INTEGRITY;NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
query_rewrite_integrity string TRUSTED
SQL> show parameter QUERY_REWRITE_ENABLEDNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
query_rewrite_enabled string TRUE
SQL> show parameter compatible;NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
compatible string 9.2.0.0.0
SQL> grant query rewrite to scott;Grant succeeded.SQL>2、scott
创建索引/分析表;
http://www.itpub.net/139409.html
1、sys用户
SQL> alter system set QUERY_REWRITE_INTEGRITY=TRUSTED scope=both;System altered.SQL> show parameter QUERY_REWRITE_INTEGRITY;NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
query_rewrite_integrity string TRUSTED
SQL> show parameter QUERY_REWRITE_ENABLEDNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
query_rewrite_enabled string TRUE
SQL> show parameter compatible;NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
compatible string 9.2.0.0.0
SQL> grant query rewrite to scott;Grant succeeded.SQL>2、scott
创建索引/分析表;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货