Re: Error: -2147217865 Table or View does not exist in Oracle 9i

From: Bart the bear <bartthebear_at_gmail.com>
Date: 22 Sep 2006 12:59:41 -0700
Message-ID: <1158955180.931832.192050@e3g2000cwe.googlegroups.com>

Anthony wrote:
> In the schema that is giving you trouble (SLT6):
>
> start a sqlplus session and
> do a simple
>
> desc table_name (where table_name is table in the other schema
> SLT5)
>
> If you can not get to it. Try:
>
> desc SLT5.table_name
>
> If you can get to it, either create a public synonym for that table or
> create a private synonym within schema SLT6 or change the SQL statement
> to fully qualifed name.
>
> If you cannot get to it, you don't have select privilege to that table.

What happens if the error is generated by a missing synonym or view? Why would he do something like that when setting the event should show him precisely which SQL is problematic. Received on Fri Sep 22 2006 - 14:59:41 CDT