problems reading Oracle table created in Knime from outside Knime
Dear all,
I am using latest Knime on latest Win11, all updates installed.
I have a workflow in Knime reading a small table “LAND” from Oracle 11g and writing it into a new table “hs_output” in the same DB. Destination table is created new in DB.
I am using latest DB driver from Knime.
In Knime this workflow works perfect; reading from destination table “hs_output” runs well.
When I try to do a "select * from hs_output” on the DB using SQLPLUS or TOAD I get the message: “ORA942 table or view does not exist”.
Remark: I can see my destination table “hsoutput” in table “sysall_tables”.
Hostname, database in node Oracle Connect have been anonymized.
I am using same database user in SQLPLUS and TOAD than in Knime.
Maybe a problem with grants?
Do you have any ideas?
Thanks for help!
BR,
Heinz