From sorr@arzoo.com Thu, 05 Apr 2001 09:53:32 -0700
From: "Steve Orr" <sorr@arzoo.com>
Date: Thu, 05 Apr 2001 09:53:32 -0700
Subject: RE: Select won't work for view create
Message-ID: <F001.002E2DDA.20010405094726@fatcity.com>
MIME-Version: 1.0
Content-Type: multipart/related; boundary="Boundary..771.1077444363.multipart/related"
--Boundary..771.1077444363.multipart/related
Content-Type: text/plain
Content-Transfer-Encoding: 7bit



With 
apologies to Oracle Corporation... 


<IMG height=30 src="cid:783454116@05042001-17fe" width=127 
v:shapes="_x0000_i1025"> 
Hope they don't sue me. ;-)
 

  <FONT face=Tahoma 
  size=2>-----Original Message-----From: root@fatcity.com 
  [mailto:root@fatcity.com]On Behalf Of Kevin KostyszynSent: 
  Thursday, April 05, 2001 10:27 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Select won't work for view 
  create
  Now 
  that is one fancy signature!
  
    <FONT face=Tahoma 
    size=2>-----Original Message-----From: root@fatcity.com 
    [mailto:root@fatcity.com]On Behalf Of Koivu, LisaSent: 
    Thursday, April 05, 2001 1:03 PMTo: Multiple recipients of list 
    ORACLE-LSubject: RE: Select won't work for view 
    create
    Hi 
    Dan, 
    <SPAN 
    class=768480816-05042001> 
    <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@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 
          NOSEND="1"><IMG alt=NeoMedia border=0 height=26 id=_x0000_i1027 
          src="http://www.neom.com/images/email_img/neomlogo.gif" width=135 
          NOSEND="1"><IMG border=0 height=2 id=_x0000_i1028 
          src="http://www.neom.com/images/email_img/1px.gif" width=1 
          NOSEND="1">4850 N. State Rd. 7, #G104
          <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 
          NOSEND="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 NOSEND="1">
        <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@cdicorp.com]Sent: Thursday, April 05, 2001 
      12:36 PMTo: Multiple recipients of list 
      ORACLE-LSubject: Select won't work for view 
      create
      <SPAN 
      class=755183615-05042001>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> 
      <SPAN 
      class=755183615-05042001>FWIW Oracle 8.0.6 on DG-UX
      <SPAN 
      class=755183615-05042001> 
      <SPAN 
      class=755183615-05042001>Dan
 image001.gif

--Boundary..771.1077444363.multipart/related
Content-Type: application/octet-stream; name="msg06067"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="msg06067"
Content-Description: ""

--Boundary..771.1077444363.multipart/related--