imp to replace old data and user
Dear Guru, need help ?
I am not an DBA, and I need to : EXP from one computer and then IMP to another computer.
What I am doing now is :
computer 1 :
exp userid=system/password@compu1 owner=acc;
computer 2, already have user acc and old data
using sql plus :
drop user acc;
create user acc identified by acc;
grant all privileges to acc
then
imp userid=system/password@compu2 fromuser=acc touser=acc
Is there anyway to import data to computer 2 without drop user and create new user ?
I mean IMP statement or parameter with replace the user, instead of always drop and create new user ?
Maybe something like
imp userid=system/password@compu2 fromuser=acc touser=acc replace=Y ???
I am doing this, because user need data to play or to test so I restore it in computer 2.
Thank you very much