ALLOW_LEVEL_WITHOUT_CONNECT_BY

Recommended Value: TRUE

This parameter is set to avoid following error,
  • After Upgrading To Oracle 10g, Getting ORA-01788 When Running A Query That Includes The LEVEL Pseudo Column [ID 455953.1]