| IMPDP: How to update table, if primary-key already exists? [message #215894] |
Wed, 24 January 2007 03:52  |
gaurav_knowledge
Messages: 3
Registered: January 2007
|
Junior Member |
|
|
Hi,
I am using the impdp utility of Oracle 10g. I want that if the table to which I am importing has the same primary key as the data of .dmp file (from which I am importing), then that row in table will be updated, and if the primary key doesn't exists, that that row is inserted.
impdp allows you to specify a table_exists_action, which can be SKIP, APPEND, REPLACE or TRUNCATE. But none of them can do what I desire, i.e INSERT/UPDATE depending on (PK doesn't exists)/(PK exists). DB2 IMPORT command can do it by specifying INSERT_UPDATE. Is there a way around for this in Oracle 10g?
thanks,
Gaurav
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
