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: Error: -2147217865 Table or View does not exist in Oracle 9i

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

From: Anthony <akkha1234_at_gmail.com>
Date: 22 Sep 2006 11:35:41 -0700
Message-ID: <1158950141.165458.180020@m73g2000cwd.googlegroups.com>


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

Original text of this message

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