Solutions:
用dba身份执行以下语句:
SQL> alter system set "_allow_level_without_connect_by"=true scope=both
SQL> col KSPPINM format a40
SQL> col ksppstvl format a5
SQL> select ksppinm,ksppstvl from x$ksppi a,x$ksppcv b where a.indx = b.indx and ksppinm like '%_allow%';
KSPPINM KSPPS
---------------------------------------- -----
_lm_rcvr_hang_allow_time 200
_allow_error_simulation FALSE
_allow_resetlogs_corruption FALSE
_allow_terminal_recovery_corruption FALSE
_allow_read_only_corruption FALSE
_tts_allow_charset_mismatch FALSE
_xtts_allow_pre10 FALSE
_flashback_allow_noarchivelog FALSE
_gs_anti_semi_join_allowed TRUE
_allow_commutativity TRUE
_allow_level_without_connect_by TRUE
KSPPINM KSPPS
---------------------------------------- -----
_asm_allow_only_raw_disks TRUE
_asm_allow_resilver_corruption FALSE
13 rows selected.
[@more@]
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/789833/viewspace-1038491/，如需转载，请注明出处，否则将追究法律责任。
广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员
