Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem with IGNORE=Y in imp (Import)

sankarmMay 10 2010 — edited May 10 2010

Hi 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

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 7 2010

Added on May 10 2010

#general-database-discussions

7 comments

3,378 views