Re: Import utility limitation

From: James B <james_c_ball_at_hotmail.com>
Date: 24 May 2002 03:23:53 -0700
Message-ID: <da6afe8d.0205240223.248ed14@posting.google.com>

Hi,

You used the 'ignore=y' flag, if you leave this off you will see that the import throws out loads of referential integrity constraint errors.

This is because you are trying to insert (via import) loads of employees with employee numbers which already exist - so they get rejected.

You are right that you would need to truncate the table and import, but this is not always the best way to back up data - especially when the database starts to get bigger.

J Received on Fri May 24 2002 - 05:23:53 CDT