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.

[@more@]