Re: ORA-00942: table or view does not exist" (Report 3.0)

From: Filip Hanik <>
Date: Wed, 25 Aug 1999 14:36:50 -0700
Message-ID: <klZw3.2908$>

If the table is in another user's schema then you would have to create a synonym or assign priviligies to that table for the other user. By default a user can only see tables and view in his/her own schema.


<> wrote in message news:7q1m6t$em6$
> I created a report by logging in one database, but next time if I logged
> in another DB(this one has exactly the same structure as the one I used
> to create report, just different User Name, Password, Connect String),
> the error msg comes up "ORA-00942: table or view does not exist...". But
> I need to test the report in different DB with the same structure, and
> my report should use for different database with the same structure.
> What can I do with that?
> Thank you in advance.
> Sent via
> Share what you know. Learn what you don't.
Received on Wed Aug 25 1999 - 23:36:50 CEST

Original text of this message