Illegal option for "ALTER SYSTEM"???

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 7 Jul 2010 12:21:56 +0000 (UTC)
Message-ID: <i11rh3$arq$1_at_news.eternal-september.org>

This is 10.2.0.4 on Linux x86-64:

SQL> alter system set events='1013 trace name context off' scope=both sid='*';
alter system set events='1013 trace name context off' scope=both sid='*'

                                                      *

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=false scope=both sid='*';

System altered.

Elapsed: 00:00:00.17
SQL> Why are "SCOPE=BOTH SID='*'" illegal options for alter system set events and yet work perfectly well with set global_names?

-- 
http://mgogala.byethost5.com

Received on Wed Jul 07 2010 - 07:21:56 CDT