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: <anaskhans_at_gmail.com>
Date: 16 Mar 2005 02:30:56 -0800
Message-ID: <1110969056.284807.231250@f14g2000cwb.googlegroups.com>


Hi All,
I am using the same query against 2 schemas in same server having same set of tables and data . Do you think in such a situation the seeing the query has any importance?

thanks
Anas
Michel Cadot wrote:
> "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 Wed Mar 16 2005 - 04:30:56 CST

Original text of this message

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