Unable to obtain table information on Schema imp

[Hattl]

Hello together,

I hope somebody can help me on following problem:

I cannot import DB schema from an Oracle Database.
I configured the ODBC connection to the Oracle Database and "Test Connection" was successful. But if I select this Connection in EA i always get the message "Unable To Obtain Table Information".

The database is Oracle 10 32Bit (installation on a server). I am running Windows 7 64 Bit (with 64 Bit Oracle Client)

If I try to connect to a local installed Oracle Database (64Bit), I dont get this message, but the "Available Objects" Windows is empty. (the schema I connected has tables, views, packages ...)¨

Does EA only work on 32 Bit systems / 32 Bit Oracle Clients or what might I am doing wrong?

Many thanks for you help and best regards

Hattl

[qwerty]

Usually this is a problem with user rights. Try as DBA.

q.

[Hattl]

Thank you for helping,

the user on the local Oracle DB (Oracle 11) has the Role privileg "dba".

In the meantime I got i to retrieve data from the Oracle 10.2 database. It worked after I added a new Datasource (with the same connection parameters) within EA. But with Connections created by Adminstrative Tools/Data Sources, the problem remains also on the 10.2 database.

After that I created also new connection to the local database within EA, but on Oracle 11 I am not able to retrieve table information. No error message, but no tables, view are displayed.

I checked the privileges. They are the same as for the users on the Oracle 10.2, except the user on 11 additional has role "dba".

User settings on 10.2:
Role privileges: connect, resource
System privileges: debug connect session, unlimited table space

User settings on 11
Role privileges: connect, dba, resource
System privileges: debug connect session, unlimited table space

Now I can work, but it is not very comforatable, as I always have to export/import my schema from Oracle 11 to Oracle 10.2 before using EA.

In my original question I asked if EA can work on 64Bit systems, I would like to add, can EA work with Oracle 11?

Thanks a lot for support and best regards

Hattl