Re: PL/SQL Error PLEASE HELP

Andy Hardy wrote:
>
> In article <8pt1p2$fkl$1_at_nnrp1.deja.com>, Chris Taylor
> <ctaylor_at_asapsc.com> writes
> >Ok I have an odd situation.
> >
> >We have 2 databases (one development and one test).
> >They both have a link to a respective development and test database:
> >
> >TEST1 -> LINK -> TEST2
> >DEV1 -> LINK -> DEV2
> >
 

> >SELECT * FROM EMPL_RECORD_VW_at_ABCLNK where rownum < 50;
> >
> >ERROR: ORA-00942 Table/view does not exist ORA-02063 preceding line
> >from ABCLNK.
> >
> >To get this select to work I have to specify the owner:
 

> It sounds like the link on your TEST1 database is not set up correctly.
> Try dropping it and recreating. Or you don't have the synonyms correctly
> set-up. You need to compare your two set-ups.
>
> There's not much point in speculating why bits of it work under certain
> conditions!

If the public synonym now exists and the link is correct and the table definitions are correct then is there spurious data in the table that forms the outer join? If the query works without the outer join but not with it then I'd definitely be checking the actual data in that table. Received on Tue Oct 03 2000 - 07:21:59 CDT