Q

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.

This Content Component encountered an error
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.
This was first published in September 2008

Dig deeper on Oracle database administration

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close