I don't believe it's a false error. Try doing a describe on each table and
I think you will find you do not have access to one (or both) of them.

Terry Lofgren
Database Administrator
Hudson Bay Mining and Smelting Co., Ltd.
1 Company Road
Flin Flon, MB R8A 1N9
(204)-687-2283


-----Original Message-----
From: Kerber, Andrew . MS-AK [mailto:[Email Address Removed] November 30, 2001 3:20 PM
To: LazyDBA.com Discussion
Subject: RE: create view


Its a false error, what its really telling you is it doesnt know what table
each field is coming from, try prefixing the field names with a. or b.,
whichever is appropriate.

-----Original Message-----
From: Dancy, Jerry A (Jerry)** CTR ** [mailto:[Email Address Removed] Friday, November 30, 2001 15:16
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 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