Re: Incremental Schema DDL

Brian,

Oracle provides some wonderful tools called ETI and EDI which will do exactly what you need.

ETI = Export, Truncate, Import (Works good on tables) EDI = Export, Drop, Import (Works great on schemas)

Sorry for being a smart a**, but thats how most of the world does it.

"Brian S. Fritsche" <bfritsche_at_webbmason.com> wrote in message news:9uobh5$hes_at_netaxs.com...
> We are a relatively new Oracle user, and I'm wondering which (if any) tool
> that came with Enterprise Edition allows me to take one database (our
> Development Environment), compare it's schema to our "Test" Environment
 and
> have an incremental set of DDL produced automatically.
>
> By "incremental", what I'm looking for is a set of DDL that will bring
> Database B (Target) up to the exact schema of Database A (Source).
>
> Is this an easy one?
>
>
Received on Fri Dec 07 2001 - 04:30:46 CET