Oracle Retrieve schema doesn't work

[Anonymous]

Hi.

I have upgrade talend version from 5.3 to 6.5.1

I have import the oracle db connection from the previous version. If I use the table already in the table schema as toracleinput the job work correctly.

If I try to add a new table in the retrieve schema like the figure above

but no table is in my table list

If I try to add schema directly from the schema list like the table "PROVA"

when I press the finish button I have this error

Why this?

Monica

[Anonymous]

Good question, but I don’t think so. I’m assuming your schema reader traverses Oracle dictionary (all_tables, all_views). The Scott/tiger schema (Scott schema was what I wanted to read) is aviablave to all. Anyhow, feel free to close this thread. Apologize for keeping it open (I can’t figure how to close it). Cheers! Ar

[Anonymous]

Hello @ar ,

Don’t hesitate to post your issue here and feel free to create a jira issue on talend bug tracker if needed.

Best regards

Sabrina

[Anonymous]

Hello everyone,,

Are you able to create a new oracle DB connection and retrieve schema on v 6.5 successfully ?
I have the Oracle 12.1x sid connector working and a simple "select * from scott.dept" query working.
The "retrieve schema" for SCOTT however does not work.
Best regards