Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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..
0683p000009MCoO.jpg 0683p000009MCoT.jpg
Labels (2)
4 Replies
Anonymous
Not applicable
Author

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

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 ?
Anonymous
Not applicable
Author

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"
Anonymous
Not applicable
Author

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