Re: DBDiff with generating Update Script(B

Hallo Michael,

Import doesn't drop already existing objects. ignore=y only means, that import will continue after failed creation of an object. Simplest suolution is to drop (cascade) and recreate the user, or , if you have some object-privileges to keep, drop all objects in the schema before importing.

hth
Stephan

Michael Buresch schrieb:

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

--
Mit freundlichen Gr$B|_(Ben

Stephan Langer,
QITS GmbH