Hello everybody,
I would like to ask someone for help with creating a physical model of our Oracle DB. I tried to read a lot of stuff about it, but with no success to solve my problem.
Our project DB has a lot of schemas, with a lot of tables and other objects within each other. I've got the task to make a physical model from it. I've tried to reverse engineer it, which is functioning, but I would like to preserve DB structure in the model so that each schema in DB would have corresponding separate package in model, because when I just import from ODBC to one package, it get's really messy, as project browser doesn't show schema/owner name before the object name, like i was able to achieve in diagram, where it works fine for me.
I was able to achieve individual import from ODBC per schema into separate packages via right click on each package and choosing Code Engineering > Import DB Schema from ODBC. But here starts the problem. All Foreign keys are defined on each imported table (in project browser), but if I right click on the table and show properties, there are defined just links to corresponding tables that are also inside the package. There is no link to table that is in another package (representing another schema), even if there is FK defined on that table, to another table in another package. EA just doesn't know where to find the table of the opposite side of the relationship. As a result, when i place a table on the diagram and choose Import related elements (from the context menu), it shows me only tables that are inside that package, but not the ones belonging to relationships (FKs) that direct to table in another package.
Is there a way to tell EA where it finds tables that are in another package representing another schema? I would need to achieve this automatically, because there are hundreds of tables in database, so manual defining every link would be very time consuming.
I'm using Oracle 11.2 and Enterprise Architect 13.5
Thank you in advance for any suggestions.
