problem with v$views

Hi All,
i am using Oracle 9i.

i am facing one problem here,
i am able to select from v$view but unable to create view on that as described below
Please suggest.

DEV13>select * from v$mystat where rownum<2;

SID STATISTIC# VALUE
---------- ---------- ----------
43 0 1

DEV13>create or replace view stats
2 as select 'STAT...' || a.name name, b.value 3 from v$statname a, v$mystat b
4 where a.statistic# = b.statistic#
5 union all
6 select 'LATCH.' || name, gets
7 from v$latch
8 union all
9 select 'STAT...Elapsed Time', hsecs from v$timer; from v$statname a, v$mystat b
*
ERROR at line 3:
ORA-01031: insufficient privileges

Please suggest.

Thanks in Advance
Pratap Received on Tue May 09 2006 - 06:59:45 CDT