Path: news.easynews.com!core-easynews!newsfeed3.easynews.com!easynews.com!easynews!news.glorb.com!wn12feed!worldnet.att.net!207.35.177.252!nf3.bellglobal.com!nf1.bellglobal.com!nf2.bellglobal.com!news20.bellglobal.com.POSTED!not-for-mail From: dbyy User-Agent: Mozilla Thunderbird 0.5 (Windows/20040207) X-Accept-Language: en-us, en MIME-Version: 1.0 Newsgroups: comp.databases.oracle.tools Subject: Re: changing open_cursor in TOAD References: <24IGc.22790$WM5.1031968@news20.bellglobal.com> In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Lines: 49 Message-ID: Date: Wed, 07 Jul 2004 07:41:06 -0400 NNTP-Posting-Host: 67.68.7.163 X-Complaints-To: abuse@sympatico.ca X-Trace: news20.bellglobal.com 1089200353 67.68.7.163 (Wed, 07 Jul 2004 07:39:13 EDT) NNTP-Posting-Date: Wed, 07 Jul 2004 07:39:13 EDT Organization: Bell Sympatico Xref: core-easynews comp.databases.oracle.tools:64982 X-Received-Date: Wed, 07 Jul 2004 04:53:23 MST (news.easynews.com) sybrandb@yahoo.com wrote: > dbyy wrote in message news:<24IGc.22790$WM5.1031968@news20.bellglobal.com>... > >>hi everyone, >> >>I wonder whether someone can tell me - I'm sure someone can :-) -, >>why I can change the open cursor in one installation through TOAD >>and in another install I can't. >>These are two totally different installations. >>One install is Oracle 9.2 (can change cursors) the other one is Oracle >>V 8.1.5 (can't change cursors). >> >>Same is when I try to change the cursors through SQL*Plus, one is >>working, the other is not. >> >>I assume at the end it's the installation of Oracle. >>One install (V 9.2 which is working) I did by myself (default install), >>the other was installed by someone else (seems to me is a customized >>install) and possibly not proper installed. >> >>Might be someone can point me to the problem. >> >>Any help much appreciated. >> >>Tkx >> >>Fred > > > > In Oracle 9i you have the option to change dynamically almost all parameters. > This is a new feature of 9i. > And Oracle 8.1.5 was desupported in the previous century. > > Sybrand Bakker > Senior Oracle DBA Thank you Sybrand for your reply. The reason to talk about Oracle 8.1.5 is, because there are companies out there that still using older version of a database system (and V 8.1.5 is still available on Oracle's website). Do I have to understand your posting so that open_cursors can't be changed on Oracle V 8.1.5 through TOAD or SQL*Plus ? Thanks for taking the time.. Regards Fred