STEP TO FOLLOW :
Copy the dmp files to your first level on drive C. Ie c:\ SCOOT_20111129_0218.dmp
To make it easier, rename the file to SCOOT.dmp
Open command promt ( CMD ) and set your cursor to the file :
Make sure :
There are no table with the same name in the archive schema. If there are, please rename that table to other name.
You have the right system user password. It won’t work if you don’t have this login credential.
Recite the selawat 3 times.
Execute this statement :imp system/pwd_ok@LISTDB1 file=SCOOT.dmp fromuser=SCOOT...
