ORA-01788: CONNECT BY clause required in this query block For ORACLE 10G
ORA-01788: CONNECT BY clause required in this query block
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.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/789833/viewspace-1038491/ ，如需转载，请注明出处，否则将追究法律责任。
