Home » RDBMS Server » Server Administration » Underscore parameters in Oracle 10g
Underscore parameters in Oracle 10g [message #63121] Mon, 13 September 2004 01:15 Go to next message
shameer
Messages: 5
Registered: October 2003
Junior Member
Hi Guys,

I'm facing "ORA-01788 CONNECT BY Clause required  in the query block" error when i run the query for 10g database. The same query works fine in 9i database. So to fix this problem, oracle support recommends to set the "_allow_level_without_connect_by " parameter to TRUE. Can anybody tell me how & where to change / include the underscore parameters in oracle 10g.

Report message to a moderator

Re: Underscore parameters in Oracle 10g [message #63132 is a reply to message #63121] Mon, 13 September 2004 09:21 Go to previous messageGo to next message
Ben
Messages: 48
Registered: January 2000
Member
Would it not be the SpParameter (or init<SID>.ora) file ?

Report message to a moderator

Re: Underscore parameters in Oracle 10g [message #64529 is a reply to message #63121] Fri, 04 February 2005 03:22 Go to previous message
Bathmasivaraj A
Messages: 1
Registered: February 2005
Junior Member
Use below command,

alter system set "_allow_level_without_connect_by" = true;

Report message to a moderator

Previous Topic: OracleTNSListerner80 is not starting
Next Topic: The rollforward and rollback phase in instance recovery
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 10 03:33:04 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.