1. export data from db
exp developer/welcome@david file=d:\exp.dmp
exp PRPCAPPD1/welcome@aa file=d:\PRPCAPPD1.dmp owner=PRPCAPPD1 log=d:\PRPCAPPD1.log
exp SPRAPPD1/welcome@aafile=d:\SPRAPPD1.dmp owner=SPRAPPD1 log=d:\SPRAPPD1.log
2. import data from db
imp system/manager@paul file=d:\exp.dmp full=y
imp PRPCAPPD1/welcome@aa fromuser=PRPCAPPD1 touser=PRPCAPPD1 file=d:\PRPCAPPD1.dmp log=d:\PRPCAPPD1.log
imp SPRAPPD1/welcome@aa fromuser=SPRAPPD1 touser=SPRAPPD1 file=d:\SPRAPPD1.dmp log=d:\SPRAPPD1.log