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: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Tue, 15 Mar 2005 13:35:55 +0100
Message-ID: <d16km9$4tl$2@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
Received on Tue Mar 15 2005 - 06:35:55 CST

Original text of this message

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