Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Error: -2147217865 Table or View does not exist in Oracle 9i
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. Received on Fri Sep 22 2006 - 13:35:41 CDT