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!

update V$PARAMETER

785153Mar 29 2011 — edited Mar 29 2011

I have Windows XP and 10.2.0.1.0

I log in DB as sysdba, however I got the errors as below. Please help.

SQL> update V$PARAMETER set value = 'TRUE' where name = 'GLOBAL_NAME';
update V$PARAMETER set value = 'TRUE' where name = 'GLOBAL_NAME'
*
ERROR at line 1:
ORA-02030: can only select from fixed tables/views

This post has been answered by Chinar on Mar 29 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 26 2011

Added on Mar 29 2011

#general-database-discussions

4 comments

3,512 views