By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
I have two similar Oracle installations, one at my office and one at my house. I have taken a full dump of all the work I did during the week and need to import it to my office system. What command can I use to just import and overwrite the existing tables in my office installation, since the dump content is more current? My export was done with the following command: exp username/password@sid full=n file=C:dumpfile.dmp log=C:dumplog.log owner=(userid) statistics=none
Oracle will not overwrite the old tables. If the table already exists, you will get an error when importing the table unless the IGNORE=Y parameter is used. If this parameter is used, Oracle will not overwrite the data in the table, but will append to the table. So in your scenario, the IGNORE=N parameter runs the risk of getting duplicated data. It is best to drop the tables in the dump file before importing the new data.