Skip to Main Content
Forums

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!

Ignore existing data using impdp

TJ_TayJan 4 2016 — edited Jan 4 2016

Hi all

Please advise if there is any ways to import data without replacing those existing row of data.

Eg, if Mapping_id  is the Primary Key

Imported Table

Mapping_id     Name

1                    John

2                    Peter

3                    Mary

Target Table

Mapping_id     Name

1                    Shawn

4                    Michael

5                    Bay

Result Table

Mapping_id     Name

1                    Shawn

2                    Peter

3                    Mary

4                    Michael

5                    Bay
This post has been answered by Stefan Abraham on Jan 4 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 1 2016
Added on Jan 4 2016
#database-key-features, #export-import-sql-loader-external-tables
3 comments
2,119 views