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!

how to update gv$version

user2015671May 23 2011 — edited May 24 2011

------------------------------------------------------
SQL> select * from gv$version;

INST_ID BANNER
---------- --------------------------------------------------------------------------------
1 Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
1 PL/SQL Release 11.1.0.6.0 - Production
1 CORE 11.1.0.6.0 Production
1 TNS for HPUX: Version 11.1.0.6.0 - Production
1 NLSRTL Version 11.1.0.6.0 - Production
------------------------------------------------------

SQL> update gv$version set name='Oracle Database 11g Standard Edition Release 11.1.0.6.0 - 64bit Production' where name='Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production';
update gv$version set name='Oracle Database 11g Standard Edition Release 11.1.0.6.0 - 64bit Production' where name='Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production'
*
ERROR at line 1:
ORA-02030: can only select from fixed tables/views

------------------------------------------------------
SQL> grant update on gv$version to sys;
grant update on gv$version to sys
*
ERROR at line 1:
ORA-02030: can only select from fixed tables/views
------------------------------------------------------

I wanted to update v$version view..
Please let me know how i can do that???

Thanks,

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 21 2011

Added on May 23 2011

#general-database-discussions

25 comments

1,792 views