I created an Oracle connector and then configured it. I can then see all tables. Then I select the tables it shows up the SQL query like "select * from s_contact". Then click next and I get "ORA-009942: table or view does not exist".
I have full access to DB. Queries are working fine when from Oracle SQL window. One thing I know tables I want to select are not in my schema they are in different user schema. But I have full access to it. I also tried modifying the query to "select * from siebel.s_contact" which we use when we run queries from Oracle SQL*plus. But that didn't work either.
Log in to post a comment.