Have you qualified the view name with the schema or created a synonym?

Daniel A. Fattore
-----Original Message-----
From: [Email Address Removed] [mailto:[Email Address Removed]
Sent: Monday, March 31, 2003 6:32 AM
To: LazyDBA.com Discussion
Subject: Problme with views

Hi List



I have a peculier problem with views.I am using oracle8.1.5



I have defined a view named xx. When I am selecting from view I am able to
the data.But when I describe it I am getting the below error.

After selecting the data when I issue desc xx command it is describing.



ORA-00942: table or view does not exist



I want to know why this happening.



TQ in advance



sekhar


--------
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




This e-mail is intended for the use of the recipient(s) named above. This message may not be distributed by an intended recipient without the express written authorization of the sender. This message may be an attorney-client communication and as such privileged and confidential. If you are not an intended recipient, you may not review, copy or distribute this message. If you have received this communication in error, please notify us immediately by e-mail and delete the original message and destroy all copies.



Oracle LazyDBA home page