what's difference between RMAN and Exp/Imp? [message #313477] |
Sat, 12 April 2008 17:24  |
cheetongsim
Messages: 2 Registered: March 2008
|
Junior Member |
|
|
Hi.. We have a application that connecting to oracle db and store data in Oracle db and the application oracle user is called ABC and the application name is ABC and Database name is ABC too
I created a table under ABC DB user/schema and then I also create some entries in the ABC application and then I do a full exp of the ABC schema after that I drop the table that created and also delete the entries that I made in the application. After that I do a full imp of the ABC schema, the table deleted is recovered but the application entries did not got restored. Why ? The command that I used is as below. What is the way to use exp/imp to recover the application entries ?
exp=abc.dmp, full=y
username:ABC
password:
imp=abc.dmp, full=y
username:ABC
password:
But if I used the DB control/RMAN to recover, the table and the DB entries are all recovered
|
|
|
|
|