Problem with IGNORE=Y in imp (Import)
sankarmMay 10 2010 — edited May 10 2010Hi All,
My requirement is to refresh a schema with the imp command (Import). When I use IGNORE=N, then it tries to create tables which are already exists and errors out as all the tables are existing in my case (as my intensions is to refresh not to create).
If I select IGNORE=Y, this imp command is trynig to append rows. As some of the tables have no primary keys, those tables end up having same records inserted by imp which is not I wanted as a refresh.
Please let me know am I expected to follow any other approach for DB refresh for a schama when schema size is not more than 500 GB. In my case total 3 schemas (which I want to refresh) size is around 20GB.
(Thanks to admin for correcting me)
Pelase suggest me.
Thank you.
Edited by: TechMahi.com on May 10, 2010 12:55 AM
Edited by: TechMahi.com on May 10, 2010 12:55 AM