Database Software

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!

Need help to get import done without duplicating existing rows please.

1002621Nov 18 2014 — edited Nov 19 2014

Hi Experts,

Environment: 11gR2 AIX system

I had a table in database, and unfortunatly some rows got deleted few days back.Since then the table is getting updated on daily basis.

Fortunatly i have an old dump of that day/time to get my all removed data back to my table.

I want to import the data in this table without duplicate the already existing one.

I don't see any of IMPDP options like replace/skip/append helping me.

Can some one please explain me how can i achieve it..

I shall really appreciate you help if done soon, as it is bit urgent(sorry to say that).

Regards,

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 17 2014

Added on Nov 18 2014

#database-key-features, #export-import-sql-loader-external-tables

6 comments

2,561 views