What’s the best way to import an Oracle database?

190 pts.
Tags:
Database
Oracle
Oracle error messages
Oracle import/export
Oracle migration
Oracle replication
I have two databases in two different computers, but my databases are the same name, service and password. I recently updated the structure of one and backed it up using exp full=n file=*** and log=*** etc. I now want to imp this backup to the second machine so as to avoid repetitive work. Each time I did, it complained that tables already exist. What tricks or instructions can I use?

Answer Wiki

Thanks. We'll let you know when a new response is added.

It sounds like you want to import a schema that has the same username as the database you are importing to. Easiest way to do this is to create another user in the second database, with the same grants as the first. Then run imp using the <b>FROMUSER=originaluser TOUSER=newuser</b> arguments. You don’t want to run a full import because then it will try to recreate the data files and reload catalog information. If you have multiple users you want to import, you will have to repeat the above process for each schema.

Hi,

This means tables already exists with the same name, if you want to insert tables which already exist then u can use ignore=y option in import it will check if table already exist it wont return error, instead it will append.

Hope this helps

regards

http://www.oracledbarea.blogspot.com

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

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

Forgot Password

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

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

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

Thanks! We'll email you when relevant content is added and updated.

Following