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.
Dig Deeper on Oracle database administration
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.