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: Nizam <nizamuddinmohd_at_gmail.com>
Date: 22 Sep 2006 13:45:31 -0700
Message-ID: <1158957931.849552.211900@b28g2000cwb.googlegroups.com>


Thanks buddy.

It works.
:)

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.
Received on Fri Sep 22 2006 - 15:45:31 CDT

Original text of this message

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