I have two database, says A and B. They are same, expect the data records are newest or old. I want to exp from the newest one (A) and imp to the older one (B).
when I import to the old one by the following command
imp username/password file=xxx.dmp fromuser=Auser touser=Buser
this will not actually import as the B already have all the tables.
So any one know is there a command for import and replace the current DB. Thank you
By the way, I am using Oracle