Manage Learn to apply best practices and optimize your operations.

Tips for using parameters in an Oracle dump file import

Oracle expert Brian Peasland explains the function of certain parameters when importing an Oracle dump file from one Oracle server to another.

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

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.