topic Re: Oracle Express 10G retrieve schema problem in Talend Studio

Oracle Express 10G retrieve schema problem

Anonymous — Sat, 16 Nov 2024 14:16:07 GMT

Hi,
I'm using TOS 2.4.0 r 14858.
I made an oracle connection with an oracle express on my computer (working in local)
but i can't retrieve schema whith my connection in metada because :"any table exist"
although when I put a schema manualy whith an existing table a can read my table ...
My user have all privilege
I don't know what I miss...
see pic
Thanks..

Re: Oracle Express 10G retrieve schema problem

Anonymous — Mon, 04 Aug 2008 12:48:03 GMT

Hello,
You have to put something in the "Schema" field!
Everything is OK with my Oracle express

Re: Oracle Express 10G retrieve schema problem

Anonymous — Mon, 04 Aug 2008 13:09:11 GMT

What sort of schema ? in oracle express it's says it is optional ...
What kind of schema I have to put ?
DO you have an example please ?

Re: Oracle Express 10G retrieve schema problem

Anonymous — Mon, 04 Aug 2008 13:22:48 GMT

I have uninstalled Orace Express few weeks ago. So I can't give you example.
Maybe Oracle express says that schema is optional, but Talend needs it.
So you have to create a schema.
I remember there is a sample database with Oracle express and the schema of this db is "HR"

Re: Oracle Express 10G retrieve schema problem

Anonymous — Mon, 04 Aug 2008 13:25:15 GMT

CORRECT,
I just find, if the shema is HR you can see the table of the user HR, if you put SYs you can sys the SYS table etc ...
Thanks very much !!!