Hi Sparx,
I've recently started using Enterprise Architect v13 (build 1310) on Windows 10 Pro x64, using Oracle's latest ODBC drivers (12.02.00.01) to talk to a particularly large database (1203 tables, 3430 stored procedures, 3900 views, 3600 triggers).
I'm trying to use the Code->Data Models->DB Schema Import. I've succesfully set-up my ODBC connection to the database and can list the schema's available in the DB and start the import process, selecting tables, etc.
When I select all 1203 tables, Enterprise Architect imports all tables as entities on a diagram, however, all entities are empty (meaning: no columns, no links/relations/empty, only the name of the table is correctly imported). Consequently, there are no links/relations between the entities which means you simply get a square map with 1203 cubes.. not very insightful!
In the system output log of Enterprise Architect, I see the following error: "ORA-01795: maximum number of expressions in a list is 1000"
When I limit my selection to say 10 tables, I notice that the import takes considerably longer, and I get columns and relations. Unfortunately, shift-selecting does not work in the table list and so I would have to manually one-by-one select say 900 tables, and then on a second import the remaining 303 - you'll understand that that's not a real option :-).
There are known workarounds for avoiding ORA-01795 and I hope that Sparx can implement those in order to fix this bug: doing so would allow Enterprise Architect to actually interact with large scale "Enterprise" databases and would give me insight into how the database is structured visually.
Kind regards + hoping for a fix,
Rubin
