Question

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

Oracle import/export, Oracle replication, Oracle migration, Oracle error messages, Oracle, Database

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?

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 FROMUSER=originaluser TOUSER=newuser 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