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
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
![]() |
![]() |