Receiving "ORA-00942: table or view does not exist" error in MetaMatrix Designer preview

Solution Verified - Updated -

Issue

  • I just created a JDBC import from our Oracle database. I selected the schema and tables that I wanted to pull back. I now see it under my folder in the MetaMatrix Designer
  • I can expand the model and see the tables, but when I go to preview, I get "Error occurred on connector  - [MetaMatrix][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist"

Environment

  • MetaMatrix Enterprise Designer 5.5.4
  • Oracle Relational Database

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.