Home » SQL & PL/SQL » SQL & PL/SQL » what's difference between RMAN and Exp/Imp? (Oracle 10g Solaris 10)
what's difference between RMAN and Exp/Imp? [message #313477] Sat, 12 April 2008 17:24 Go to next message
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
Re: what's difference between RMAN and Exp/Imp? [message #313478 is a reply to message #313477] Sat, 12 April 2008 17:40 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
You did not follow the posting guidelines as stated in URL above

>I also create some entries in the ABC application
I/we have NO idea EXACTLY what you did but it appears what ever changes you made did NOT involve the ABC schema.

You're On Your Own (YOYO)!
Re: what's difference between RMAN and Exp/Imp? [message #313487 is a reply to message #313477] Sun, 13 April 2008 01:34 Go to previous message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
In addition, all documentation is on http://tahiti.oracle.com, you will there the answer of your title question.

Regards
Michel
Previous Topic: Mass Insert /Update /Delete
Next Topic: Accessing the plan table
Goto Forum:
  


Current Time: Sat Feb 15 11:49:13 CST 2025