Re: Reverse engineer Oracle 8.1.7 and recreate problems

[Quoted] I have reverse engineered 8i databases with designer 6i and no tables changed names. It sounds like what happens when you have singular names in your logical model then generate a physical model. Did you do more than a straightforward reverse engineer?

"Stefan Heckler" <sheckler_at_psi.de> wrote in message news:3e19f7c8.0205220221.455a38fb_at_posting.google.com...
> Hi all,
>
> I try to reverse engineer an oracle 8.1.7 database with designer 6i
> and table to er retrofit tool. The reverse engineering workes quite
> fine, but the tables I regenerate from the ER model are not as
> expected: The table names are renamed to their plural name, indexes
> are generated, that I do not want. Is there any documented way to get
> exactly the same out, which was reverse engineered?
> I would like to maintain my data model as ER diagramm and regenerate
> the database with sequences, indexes, primary and foreign keys from
> the ER model.
> But first it must work to reverse engineer an existing database and
> regenerate exactely the same database with exactly the same indexes
> (same names), which I did not succeed in so far. Has anybody already
> experience with this kind of stuff?
> Any documentation hint very welcome
> Thanks
>
> Stefan Heckler, PSI AG (sheckler_at_psi.de)
Received on Thu May 23 2002 - 23:08:05 CEST