RE: Select won't work for view create

From: Koivu, Lisa <lkoivu_at_qode.com>
Date: Thu, 05 Apr 2001 09:11:32 -0700
Message-ID: <F001.002E2BCB.20010405090244@fatcity.com>

Hi
Dan,
<SPAN
class=768480816-05042001> 
are
you referencing public synonyms in your statement? <SPAN
class=768480816-05042001><FONT color=#0000ff face=Arial size=2> 

<TABLE border=0 cellPadding=0 cellSpacing=0 style="mso-cellspacing: 0in; mso-padding-alt: 0in 0in 0in 0in">      

    <TD colSpan=2
    style="PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; PADDING-TOP: 0in"     vAlign=top>

      
      


      <SPAN 

      style="COLOR: navy; FONT-FAMILY: Papyrus; FONT-SIZE: 15pt; mso-bidi-font-size: 12.0pt">Lisa 
      Rutland Koivu<SPAN 
      style="COLOR: navy; FONT-FAMILY: 'Monotype Corsiva'; FONT-SIZE: 7.5pt"><SPAN 
      style="COLOR: navy; FONT-FAMILY: Verdana; FONT-SIZE: 10pt">Oracle Database 
      Administratorlkoivu_at_qode.com<SPAN 
      style="COLOR: navy; FONT-FAMILY: Verdana; FONT-SIZE: 7.5pt"><IMG 
      border=0 height=20 id=_x0000_i1026 
      src="http://www.neom.com/images/email_img/1px.gif" width=1><IMG 
      alt=NeoMedia border=0 height=26 id=_x0000_i1027 
      src="http://www.neom.com/images/email_img/neomlogo.gif" width=135><IMG 
      border=0 height=2 id=_x0000_i1028 
      src="http://www.neom.com/images/email_img/1px.gif" width=1>4850 N. 
      State Rd. 7, #G104<?xml:namespace prefix = o ns = 
      "urn:schemas-microsoft-com:office:office" />


      <SPAN 

      style="COLOR: navy; FONT-FAMILY: Verdana; FONT-SIZE: 7.5pt">Ft. 
      Lauderdale, FL 33319


      <SPAN 

      style="COLOR: navy; FONT-FAMILY: Verdana; FONT-SIZE: 7.5pt">Phone: 
      954.484.3191


      <SPAN 

      style="COLOR: navy; FONT-FAMILY: Verdana; FONT-SIZE: 7.5pt">Fax: 
      954.484.2933


      <SPAN 

      style="COLOR: navy; FONT-FAMILY: Verdana; FONT-SIZE: 7.5pt"><A 
      href="http://www.neom.com/">www.neom.com<A 
      href="http://www.paperclick.com/">www.paperclick.com<A 
      href="http://www.qode.com/">www.qode.com<IMG border=0 height=20 
      id=_x0000_i1029 src="http://www.neom.com/images/email_img/1px.gif" 
      width=1>
  

    <TD
    style="PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; PADDING-TOP: 0in">
<A

      href="http://www.paperclick.com/home.htm"><IMG 
      alt="P a p e r C l i c k . c o m" border=0 height=37 id=_x0000_i1030 
      src="http://www.neom.com/images/email_img/PaperclickLogoFrameW.gif" 
      width=63>

    <TD
    style="PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; PADDING-TOP: 0in">

    <TD
    style="PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; PADDING-TOP: 0in">       

    <TD
    style="PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; PADDING-TOP: 0in; WIDTH: 45pt"     width=60>

 

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Dasko, Dan   [mailto:Dan.Dasko_at_cdicorp.com]Sent: Thursday, April 05, 2001 12:36   PMTo: Multiple recipients of list ORACLE-LSubject:   Select won't work for view create
  I
  have a select that works fine.  However, it doesn't work fine when I try   to create a view of the result set.  There is nothing particularly fancy   about the query, just a plethora of outer joins from the main table to the   secondary tables.  I get an error back about one of the tables not   existing, but like I said, it works as a select, just not as a create view as   ... 
  <SPAN
  class=755183615-05042001> 
  FWIW
  Oracle 8.0.6 on DG-UX
  <SPAN
  class=755183615-05042001> 
  <SPAN
  class=755183615-05042001>Dan Received on Thu Apr 05 2001 - 11:11:32 CDT