Re: DBDiff with generating Update Script

[Quoted] Hallo Guang,

O.K. I tried the export with:

exp80 faktura/faktura_at_foracle rows=no direct=y grants=n file=struct_faktura_net.DMP

After that I tried the import with:

imp80 test/test _at_foracle rows=no grants=n file=struct_faktura_net.dmp full=yes

(also instead fille=y with fromuser=faktura)

Now I get an error message that some objects already exists.

O.K. I can say imp80 with the paramter ignore=y than it looks only that it works. After that i run DBDiff:

FAKTURA TEST VIEW COLUMN TYPE TYPE

ARTIKEL_VIEW No Structural Differences Found

LAGERBEWEGUNG_VIEW PREIS NUMBER(21,4) NUMBER(19,4) MAHNUNG4_VIEW No Structural Differences Found

MAHNUNG5_VIEW No Structural Differences Found

VORGANG_DETAIL_VIEW BEMERKUNG VARCHAR2(2000) VARCHAR2(300) So in this case there where differences. Can you help?

"Guang Mei" <gmei_at_proteome.com> schrieb im Newsbeitrag news:26wi7.2041$Fn4.323423_at_news.shore.net...
> Well, maybe you can use oracle's exp and imp utility to get same database
> structure, use row=n when doing imp will only load structure (no data).
>
> Guang
>
> "Michael Buresch" <MBu_at_b-w-computer.de> wrote in message
> news:9mdiv4$p6a$00$1_at_news.t-online.com...
> > Hallo,
> >
> > I am looking for a Tool. I have two databases and want to create an
update
> > script to get the same database structure (without data!). How can I
> realize
> > it?
> >
> > I tried it with a demo from DKG (DBDiff for Oracle) but I can't create
an
> > update script with it.
> >
> > Michael
> >
> >
>
>
Received on Tue Aug 28 2001 - 11:12:08 CEST