I see so much posted about this IGNORE parameter - forgive me I have been a Sybase and MS SQL Server DBa for the last 8 years but I am not even sure why it would be used other than refreshing data over top an existing schema - If I understand it correctly?
This will not work in my case this time becuase this export came from a customer.
And again I am puzzled becuase I drop and recreate the user and therefore shouldnt get any duplicate key errors - and to make things worse the primary key (the blows up) is not on the table after the import is finsihed!? It must be some other users'?