error in creating view on v$

From: Harvinder Singh <Harvinder.Singh_at_MetraTech.com>
Date: Wed, 16 Nov 2005 18:12:46 -0500
Message-ID: <D6424CD4C8A3C044BBC49877ED51C51801DBAD9B@ex2003.metratech.com>

Hi,

I am trying to create view and getting following error: SQL> 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;
      from v$statname a, v$mystat b
                         *

ERROR at line 3:
ORA-01031: insufficient privileges

This user have a dba privileges. Do I need to give any other privileges to this user?

Thanks
--Harvinder

--

http://www.freelists.org/webpage/oracle-l Received on Wed Nov 16 2005 - 18:18:25 CST