Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Table or view does not exit when try to view data in physical layer

630071Apr 28 2008 — edited May 1 2008

Hi,

In BI administration tool, I was trying to import oracle tables, I was able to import the structure. I was using my own ID, but the tables are belong to different schema, I have read access on the tables. When I try to view data, I got the following error, It seems to me this is related pre-quality the schema name. Do I have create public synonmom for the tables or I have to login as table owner? Thanks for the help.

[nQSError: 17001] Oracle Error code: 942, message: ora-00942: table or view doesnot exist at OCI call OCIStmtExecute: select count(*) from MDDB810_ENTYMAP.
[nQSError: 17011] SQL statement execution failed.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 29 2008

Added on Apr 28 2008

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

3 comments

989 views