RE: Select won't work for view create

[Koivu, Lisa]

Hi Dan,

 

are you referencing public synonyms in your statement?

 

Lisa Rutland Koivu Oracle Database Administrator [EMAIL PROTECTED] 4850 N. State Rd. 7, #G104 Ft. Lauderdale, FL 33319 Phone: 954.484.3191 Fax: 954.484.2933 www.neom.com www.paperclick.com www.qode.com

 

-----Original Message-----
From: Dasko, Dan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 12:36 PM
To: Multiple recipients of list ORACLE-L
Subject: 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 ... 

 

FWIW Oracle 8.0.6 on DG-UX

 

Dan