Question about the import / export process.
I know is SQL Developer I can export all the columns from a table and import into the same table on another server.
My question is - what happens with the duplicate inserts? Will it just skip or what will happen?
I have these tables I need the data to be identical - one of the tables has data the other doesn't and I need to make them match without it messing up what is already in there.
My theory is that once I export all of the rows in the form of inserts and run it on the other DB-Table it will insert all the ones it's missing and error and skip the inserts where there already exsist the row, but want to make sure this is correct.
Thanks in advance!