<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.0.6249.1">
<TITLE>AW: Problme with views</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>Can u list all the step you've done, plz.</FONT>
</P>
<P><FONT SIZE=2>Ercan</FONT>
</P>
<P><FONT SIZE=2>-----Ursprüngliche Nachricht-----</FONT>
<BR><FONT SIZE=2>Von: [Email Address Removed] [<A HREF="mailto:[Email Address Removed] SIZE=2>Gesendet am: Montag, 31. März 2003 13:32</FONT>
<BR><FONT SIZE=2>An: LazyDBA.com Discussion</FONT>
<BR><FONT SIZE=2>Betreff: Problme with views</FONT>
</P>
<P><FONT SIZE=2>Hi List</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=2>I have a peculier problem with views.I am using oracle8.1.5</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=2>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.</FONT></P>
<P><FONT SIZE=2>After selecting the data when I issue desc xx command it is describing.</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=2>ORA-00942: table or view does not exist</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=2>I want to know why this happening.</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=2>TQ in advance</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=2>sekhar</FONT>
</P>
<BR>
<P><FONT SIZE=2>--------</FONT>
<BR><FONT SIZE=2>Oracle documentation is here: <A HREF="http://tahiti.oracle.com/pls/tahiti/tahiti.homepage">http://tahiti.oracle.com/pls/tahiti/tahiti.homepage</A></FONT>
<BR><FONT SIZE=2>To unsubscribe: send a blank email to oracledba-[Email Address Removed] SIZE=2>To subscribe: send a blank email to oracledba-[Email Address Removed] SIZE=2>Visit the list archive: <A HREF="http://www.LAZYDBA.com/odbareadmail.pl">http://www.LAZYDBA.com/odbareadmail.pl</A></FONT>
<BR><FONT SIZE=2>Tell yer mates about <A HREF="http://www.farAwayJobs.com">http://www.farAwayJobs.com</A></FONT>
<BR><FONT SIZE=2>By using this list you agree to these terms:<A HREF="http://www.lazydba.com/legal.html">http://www.lazydba.com/legal.html</A></FONT>
</P>
</BODY>
</HTML>
Oracle LazyDBA home page