SEO

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

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

Frank van Bortel wrote:
> 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

You're either seeing something I don't see, Frank, or being
ridiculously facetious.

Without the query you're trying to run it's impossible to tell WHAT is
wrong. Please post the working and non-working queries so we can help
you. None of us are psychic.


David Fitzjarrell

fitzjarrell@cox.net wrote:
> None of us are psychic.
>
>
> David Fitzjarrell
>

Exactly the point I was trying to make
--
Regards,
Frank van Bortel

"Frank van Bortel" <fvanbortel@netscape.net> a écrit dans le message de
news: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

LOL

Michel Cadot

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@netscape.net> a écrit dans le message
de
> news: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
>
> LOL
>
> Michel Cadot

anaskhans@gmail.com wrote:
> 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

Nobody is clairevoyant and people report problems with their chrystal balls
lately. So if you don't mind just tell what you are doing if you want help.

The best answers are produced when people provide test cases. If you reread
your original post, you didn't include
- with what software did you get the problem (sql*plus, isql*plus, selfwritten
software using ODBC/JDBC/OCI)
- are you experiencing the problem when executing the queries on the server,
from the same client, from different clients
- which Oracle Client version is used

etc.

HTH
Holger

PS: My car is red. Why doesn't it go any faster?

Użytkownik anaskhans@gmail.com napisał:

> 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?
>

2 schemas? Same server? You just duplicated table names. Now you need to
prefix table usage with schema name, don't you?
Post your query, it might help us with quick answer.

--
Noel

anaskhans@gmail.com wrote:
> 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?

You've reported an error which is almost certainly a syntax error in
the query. There is only one way to find that and that is to look at
the query. If you don't wish to do that on usenet, then the most
appropriate course of action would be to log a tar with support.

Niall

Hi all,
Thanks for all your input.
I am using Oracle 9i(RedHatLinux) version 9.2.0.3 .
I have been trying the SAME query (no schema prefix) from sql*plus
against same set of data in two different schemas. One schema yields
result without any error but the query gives ORA-00928 error. Once
again, there is NO single change in the sql statement.

The query is very lengthy one, 14 tables involved, a bit complex and
uses ANSI joins. I cannot publish the query because I am not permitted
to do.

We had raised the issue with Oracle technical support before posting
this in this group.

We are very much sure that there is no problem in query side.

Sorry again for providing limitted information.

Thanks
Anas

"Niall Litchfield" <niall.litchfield@dial.pipex.com> wrote in message news:<1111158048.112978.230600@o13g2000cwo.googleg roups.com>...
> anaskhans@gmail.com wrote:
> > 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?
>
> You've reported an error which is almost certainly a syntax error in
> the query. There is only one way to find that and that is to look at
> the query. If you don't wish to do that on usenet, then the most
> appropriate course of action would be to log a tar with support.
>
> Niall