Path: news.cambrium.nl!textnews.cambrium.nl!feeder2.cambriumusenet.nl!feed.tweaknews.nl!postnews.google.com!c10g2000yqi.googlegroups.com!not-for-mail
From: Mark D Powell <Mark.Powell2@hp.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Illegal option for "ALTER SYSTEM"???
Date: Wed, 7 Jul 2010 06:22:52 -0700 (PDT)
Organization: http://groups.google.com
Lines: 57
Message-ID: <306d3576-166b-4707-9229-2368b3442557@c10g2000yqi.googlegroups.com>
References: <i11rh3$arq$1@news.eternal-september.org>
NNTP-Posting-Host: 192.85.50.11
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1278508972 2392 127.0.0.1 (7 Jul 2010 13:22:52 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 7 Jul 2010 13:22:52 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: c10g2000yqi.googlegroups.com; posting-host=192.85.50.11; 
 posting-account=qJFqbQkAAACYQSLN0-cvP6ydkRfuOu6u
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; 
 Hewlett-Packard; .NET CLR 1.0.3705; .NET CLR 1.1.4322; .NET CLR 2.0.50727; 
 .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; MS-RTC LM 8),gzip(gfe)
Xref:  news.cambrium.nl

On Jul 7, 8:21=A0am, Mladen Gogala <gogala.mla...@gmail.com> wrote:
> This is 10.2.0.4 on Linux x86-64:
>
> SQL> alter system set events=3D'1013 trace name context off' scope=3Dboth
> sid=3D'*';
> alter system set events=3D'1013 trace name context off' scope=3Dboth sid=
=3D'*'
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 *
> ERROR at line 1:
> ORA-02065: illegal option for ALTER SYSTEM
>
> What's going on? When I try something else, this works:
>
> SQL> alter system set global_names=3Dfalse scope=3Dboth sid=3D'*';
>
> System altered.
>
> Elapsed: 00:00:00.17
> SQL>
>
> Why are "SCOPE=3DBOTH SID=3D'*'" illegal options for alter system set eve=
nts
> and yet work perfectly well with set global_names?
>
> --http://mgogala.byethost5.com

Maybe because the correct spelling is event, not events, in the ALTER
SYSTEM command per the SQL manual which also says the parameter is not
modifiable


SQL> alter system set event =3D '1013 trace name context off'
scope=3Dspfile;

System altered.

SQL> /
alter system set event =3D '1013 trace name context off' scope=3Dboth
                 *
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified


Though strangely enough if you leave scope=3D off the command works with
events:


SQL> alter system set events =3D '1013 trace name context off';

System altered.

Posted tests use 9.2.0.6 and appear to match initial posted results,
but reference to SQL manual based on 10.2.


HTH -- Mark D Powell --