One Star

Oracle Express 10G retrieve schema problem

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..
4 REPLIES
One Star

Re: Oracle Express 10G retrieve schema problem

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

Re: Oracle Express 10G retrieve schema problem

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 ?
One Star

Re: Oracle Express 10G retrieve schema problem

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"
One Star

Re: Oracle Express 10G retrieve schema problem

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 !!!