Re: ORA-00942: table or view does not exist" (Report 3.0)
Date: Wed, 25 Aug 1999 14:36:50 -0700
Message-ID: <klZw3.2908$W5.269285_at_typhoon-sf.snfc21.pbi.net>
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.
Filip
<tianh_at_my-deja.com> wrote in message news:7q1m6t$em6$1_at_nnrp1.deja.com...
> 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 Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Wed Aug 25 1999 - 23:36:50 CEST