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 touser=ARCHIVE TABLES=TABLE_NAME_FROM_SCHEMA_SCOOT
- To make it clear :
- imp system/pwd_ok@LISTDB1 = use system login to restore, with sid ( LISTDB1 or LISTDB2 , depend your sid name)
- file=SCOOT.dmp = the dmp file name ( just put it in C drive to make it easier.
- fromuser=SCOOT = the schema name where the table created from the production db
- touser=ARCHIVE = the schema name where the table will be restore in the production server ( do not restore at the same schema or else… )
- TABLES= TABLE_NAME_FROM_SCHEMA_SCOOT = the table need to be restore ( easier if we restore the same name as the actual table. After finish restore, then rename the table )