OT RE: Select won't work for view create

From: Mohan, Ross <MohanR_at_STARS-SMI.com>
Date: Thu, 05 Apr 2001 10:14:14 -0700
Message-ID: <F001.002E2DC1.20010405094725@fatcity.com>

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="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">   <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
  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
    Hi
    Dan,
    <SPAN
    class=768480816-05042001> 
    <SPAN
    class=768480816-05042001>are you referencing public synonyms in your     statement?
    <SPAN
    class=768480816-05042001><FONT face=Arial color=#0000ff     size=2>           

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

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


          <SPAN 

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


          <SPAN 

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


          <SPAN 

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


          <SPAN 

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


          <SPAN 

          style="FONT-SIZE: 7.5pt; COLOR: navy; FONT-FAMILY: Verdana"><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 id=_x0000_i1029 
          height=20 src="http://www.neom.com/images/email_img/1px.gif" width=1 
          border=0 NOSEND="1">
      
        <TD 
        style="PADDING-RIGHT: 0in; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; PADDING-TOP: 0in">


          <A 

          href="http://www.paperclick.com/home.htm"><IMG id=_x0000_i1030 
          height=37 alt="P a p e r C l i c k . c o m" 
          src="http://www.neom.com/images/email_img/PaperclickLogoFrameW.gif" 
          width=63 border=0 NOSEND="1">
        <TD 
        style="PADDING-RIGHT: 0in; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; PADDING-TOP: 0in">
           
          
          
      
        <TD 
        style="PADDING-RIGHT: 0in; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; PADDING-TOP: 0in">
          
        <TD 
        style="PADDING-RIGHT: 0in; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; WIDTH: 45pt; PADDING-TOP: 0in" 
        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

Received on Thu Apr 05 2001 - 12:14:14 CDT