Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-00928: missing SELECT keyword
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 BortelReceived on Tue Mar 15 2005 - 06:35:55 CST