alter system reset give error
627444Mar 21 2008 — edited Jun 1 2011hi
I run following command but not working why ?
according oracle document we can reset parameters but not working .
Oracle - 9i & OS - Redhat Linux
Thanks
SQL> alter system set sql_trace=true scope=both;
System altered.
SQL> show parameter sql_trace;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sql_trace boolean TRUE
SQL> alter system reset sql_trace scope=both;
alter system reset sql_trace scope=both
*
ERROR at line 1:
ORA-00905: missing keyword
SQL> alter system reset sql_trace ;
alter system reset sql_trace
*
ERROR at line 1:
ORA-00905: missing keyword
SQL> alter system reset sql_trace scope=both sid='dbsd';
SQL> show parameter sql_trace;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sql_trace boolean TRUE