Ask the Expert

Tips for using parameters in an Oracle dump file import

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

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: