Hi Jerry,

Created the view as sys, could not create the view as other user.

Connect as sys.

-----Original Message-----
From: Dancy, Jerry A (Jerry)** CTR ** [mailto:[Email Address Removed] Friday, November 30, 2001 1:16 PM
To: LazyDBA.com Discussion
Subject: create view


Sorry gang....I realize this is probably simple, but I have looked at it
until I have reached a point of diminishing returns :)

Why will this statement not work? I get an ORA-00942 error. Oracle 8i


create or replace view sql_summary as
(select username, sharable_mem, persistent_mem, runtime_mem
from
sys.v_$sqlarea a, dba_users b
where
a.parsing_user_id = b.user_id);


--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page