Re: Reverse engineer Oracle 8.1.7 and recreate problems

[Quoted] no, just straightforward, the problems occur when running the Database Design Transforer to recreate the (existing) tables. The (existing) tables are tables of the DEFAULT DATABASE and supposed to be the template to regenerate the ddl scripts to recreate the (modified) database(s) with sqlplus.

"Van Messner" <vmessner_at_bestweb.net> wrote in message news:<ueqmtjppo51gdc_at_corp.supernews.com>...
> 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 Tue May 28 2002 - 14:38:49 CEST