Re: exp/imp

From: koert54 <koert54_at_nospam.com>
Date: Thu, 28 Feb 2002 20:51:59 GMT
Message-ID: <PLwf8.211294$rt4.21614@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:51:59 CST