Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

alter system reset give error

627444Mar 21 2008 — edited Jun 1 2011
hi
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 29 2011
Added on Mar 21 2008
11 comments
3,743 views