Import overwriting data [message #73784] |
Mon, 12 July 2004 21:07 |
Burgunan Ranjith
Messages: 1 Registered: July 2004
|
Junior Member |
|
|
I have a project where data should be imported from one machine to
another repeatedly. I have a column as primary key. How can I import data
to a table overwriting the existing records and coping the new data
records?
|
|
|
Re: Import overwriting data [message #73790 is a reply to message #73784] |
Tue, 13 July 2004 03:27 |
|
Mahesh Rajendran
Messages: 10708 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
imp will not overwrite the data.
By default it will try to APPEND the data to table.
If the target table contains primary keys, the import will fail.
So, truncate the target table data prior to import and then do the import.
use ignore=y to ignore the presence of the table.
If there are complex parent-child relationships between the tables, then just drop the table with cascade option.
|
|
|