I suspect that the import of the structure has enabled all constraints. It
then happens that import is trying to insert into a child table before
inserting into the parent table. What you probably need to do is to
identify all foreign key constraints after the first rows=n import, disable
them, and then run the second import. After which, it's just a question of
re-enabling all the disabled constraints.
Regards
HJR
--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================
"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:59:23 CST
