Moving data from one DB to another where the table/column structure is identical 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!
If you have duplicate inserts, the first question I would have would be why would you have two rows in the same table with the exact same information?

That being said, if there are no unique keys or other such constraints on the table, the new DB server should dutifully import the duplicated data.

I would heartily recommend testing it in a non production environment first, though.