RE: OT RE: Select won't work for view create

Yea
right!  Someone in the office of our new parent company had too much time on his hands...

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Mohan, Ross   [mailto:MohanR_at_STARS-SMI.com]Sent: Thursday, April 05, 2001 1:47   PMTo: Multiple recipients of list ORACLE-LSubject: OT   RE: Select won't work for view create
  Yea, I noticed
  that.
  <FONT
  face="Courier New"> 
  Lisa musta gotta
  raise.
  <FONT
  face="Courier New"> 
  <FONT
  face="Courier New">(congrats!)
  <BLOCKQUOTE dir=ltr
  style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px">     <FONT face="Times New Roman"
    size=2>-----Original Message-----From: Kevin Kostyszyn     [mailto:kevin_at_dulcian.com]Sent: Thursday, April 05, 2001 1:27     PMTo: Multiple recipients of list ORACLE-LSubject: RE:     Select won't work for view create
    <FONT color=#0000ff face=Arial
    size=2>Now that is one fancy signature!     

<FONT face=Tahoma

      size=2>-----Original Message-----From: root_at_fatcity.com 
      [mailto:root_at_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


      <SPAN 

      class=768480816-05042001>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_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 
            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_at_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