Home » SQL & PL/SQL » SQL & PL/SQL » Problem in Creating a View
Problem in Creating a View [message #223032] Wed, 07 March 2007 05:04 Go to next message
emadbsb
Messages: 334
Registered: May 2005
Location: egypt
Senior Member


Hii All

I am trying to Create that View
CREATE VIEW REDO_SPACE_REQ_VIEW AS
(SELECT  NAME , VALUE FROM  V$SYSSTAT WHERE STATISTIC# ='108');


but i got that error

ERROR at line 2:
ORA-00942: table or view does not exist



Thanks for everyone helped and helping me

Re: Problem in Creating a View [message #223034 is a reply to message #223032] Wed, 07 March 2007 05:07 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
It seems to me that you don't have access to the v$sysstat dictionary view.

MHE
Re: Problem in Creating a View [message #223036 is a reply to message #223032] Wed, 07 March 2007 05:26 Go to previous message
martijn
Messages: 283
Registered: December 2006
Location: Netherlands
Senior Member
As which user are you trying to create this view. And does this user have the aproperiate permissions?
Previous Topic: Truncate vs Delete
Next Topic: DML statement
Goto Forum:
  


Current Time: Wed Dec 07 06:47:00 CST 2016

Total time taken to generate the page: 0.16355 seconds