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