Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambriumusenet.nl!feed.tweaknews.nl!193.201.147.78.MISMATCH!feeder.news-service.com!85.214.198.2.MISMATCH!eternal-september.org!.POSTED!not-for-mail From: Mladen Gogala Newsgroups: comp.databases.oracle.server Subject: Illegal option for "ALTER SYSTEM"??? Date: Wed, 7 Jul 2010 12:21:56 +0000 (UTC) Organization: A noiseless patient Spider Lines: 26 Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Injection-Date: Wed, 7 Jul 2010 12:21:56 +0000 (UTC) Injection-Info: mx02.eternal-september.org; posting-host="/+gSUFlAJ2xR7U/4XBg2bw"; logging-data="11130"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+Ojt1dAbzyrf/wpgyq170O" User-Agent: Pan/0.133 (House of Butterflies) Cancel-Lock: sha1:IeJ6QSG/xlkolty1J/AqZEAAI0Y= Xref: news.cambrium.nl 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