Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-00928: missing SELECT keyword

Re: ORA-00928: missing SELECT keyword

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Tue, 15 Mar 2005 18:53:35 +0100
Message-ID: <423720d6$0$31175$626a14ce@news.free.fr>

"Frank van Bortel" <fvanbortel_at_netscape.net> a écrit dans le message de news:d16km9$4tl$2_at_news5.zwoll1.ov.home.nl...
| Anas wrote:
| > Hi ,
| > I have two schemas for development and testing. Both were populated
| > via import from another server.
| > I am getting "ORA-00928: missing SELECT keyword" error while I try to
| > execute a query on one schema but it works fine with the other.
| > To resolve this I deleted all the existing statitics for indexes and
| > tables, rebuilt all the indexes and collected new statistics using
| > DBMS_STATS.
| >
| > My server version is:
| > Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
| >
| > Please help
| >
| > Thanks
| > Anas
|
| Yes - in line 23, you missed a '''
|
| --
| Regards,
| Frank van Bortel

LOL Michel Cadot Received on Tue Mar 15 2005 - 11:53:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US