Thanks for your ultra speed answer .....
"koert54" <koert54_at_nospam.com> a écrit dans le message de news:
PLwf8.211294$rt4.21614_at_afrodite.telenet-ops.be...
> You're hitting your referential key constraints !
>
> Do it like this ...
> 1. imp rows=N indexes=N constraints=N
> 2. modify
> 3. imp rows=Y indexes=N constraints=N ignore=Y
> 4. imp rows=N indexes=Y constraints=Y ignore=Y
>
> But I prefer it like this
> 1. imp indexfile=index.sql
> 2. pretty print index file + search/replace new storage parameters
> (http://pretoria.sourceforge.net)
> 3. run the newly created ddl scrips for tables
> 4. imp rows=Y indexes=N constraints=N ignore=Y
> 5. run the newly created ddl scrips for indexes
> 6. imp rows=N indexes=N constraints=Y ignore=Y
> This way you can change things like initial extent, freelist, freelist
> groups etc ...
>
>
>
> "Titi" <thierry.constant2_at_wanadoo.fr> wrote in message
> news:3c7e95f5$0$8718$626a54ce_at_news.free.fr...
> > Hi,
> >
> > I export a user
> > I import only struture ( rows = n )
> > I modify the storage clause for the tables and the indexes
> > I import all the data (ignore =y ) and I have the folowing errors:
> > ORA-02291 integrity constraint (string.string) violated - parent key not
> > found
> >
> > What is wrong and what is the good way to do that ????
> >
> > Thanks for your answer...
> >
> > conf: Oracle 8.1.7, HP-UX 11.0
> >
> >
>
>
Received on Thu Feb 28 2002 - 14:58:54 CST
