Re: Reverse engineer Oracle 8.1.7 and recreate problems

I haven't round-tripped a database design in designer, but I've generated database from the tool. There are a number of reasons why you don't get a clean round trip. However, you can or could turn off index generation.

I expect you are running into the design rules built into designer. I don't think it will let you round-trip a database design which violates these rules without manual intervention. You will have to override the rules in the physical model.

• You can override the default pluralization of table names. I did this on a project where the standard was singular table names. We stopped overriding the names when we couldn't create and use the ORDER table without a lot of problems. We notified the standards people what we were doing and didn't get any objections. (Our table contains the ORDERS for the system not an ORDER.)
• Likewise designer has rules on the naming of indexes. You can override these values.
• If I remember right the sequences script is not generated by default.

On 28 May 2002 05:38:49 -0700, sheckler_at_psi.de (Stefan Heckler) wrote:

>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?

>> > 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 Wed May 29 2002 - 04:41:50 CEST