Re: Select won't work for view create

2001-04-05 Thread Pat Hildebrand
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

RE: Select won't work for view create

2001-04-05 Thread Koivu, Lisa
Hi Dan, are you referencing public synonyms in your statement? Lisa Rutland KoivuOracle Database Administrator[EMAIL PROTECTED]4850 N. State Rd. 7, #G104 Ft. Lauderdale, FL 33319 Phone: 954.484.3191

RE: Select won't work for view create

2001-04-05 Thread Kevin Kostyszyn
Now that is one fancy signature! -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]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

RE: Select won't work for view create

2001-04-05 Thread Steve Orr
work for view create Now that is one fancy signature! -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, LisaSent: Thursday, April 05, 2001 1:03 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Select won't work

RE: Select won't work for view create

2001-04-05 Thread Jack C. Applewhite
Dan, To create a view on a table, you must have Select granted directly to your User, not just via a Role, which works for Selects. Maybe that's it. Jack Jack C. ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit, Inc.Austin,

OT RE: Select won't work for view create

2001-04-05 Thread Mohan, Ross
Yea, I noticed that. Lisa musta gotta raise. (congrats!) -Original Message-From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]]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

RE: Select won't work for view create

2001-04-05 Thread Jacques Kilchoer
Title: RE: Select won't work for view create -Original Message- From: Dasko, Dan [mailto:[EMAIL PROTECTED]] 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

RE: Select won't work for view create

2001-04-05 Thread Dasko, Dan
Title: RE: Select won't work for view create That was the problem. Thanks. Dan -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]Sent: Thursday, April 05, 2001 2:31 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Select won't work for view create

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

2001-04-05 Thread Koivu, Lisa
for view create Yea, I noticed that. Lisa musta gotta raise. (congrats!) -Original Message-From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]]Sent: Thursday, April 05, 2001 1:27 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Select won't work for view

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

2001-04-05 Thread Kevin Kostyszyn
-LSubject: RE: Select won't work for view create Now that is one fancy signature! -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, LisaSent: Thursday, April 05, 2001 1:03 PMTo: Multiple recipients