backup command
exp username/password@TNS_NAME owner=EP6 file=yao_backup.dmp log=Yao_backup2.log
let’s say we are going to restore the schema on another oracle machine to the user “ep6”
Make sure the user is exist already.
To generate the user
create user ep6 identified by password;
grant all privilege to ep6;
then run restore command
imp FILE=yao_backup.dmp FROMUSER=EP6 TOUSER=EP6 GRANTS=Y FULL=N CONSTRAINTS=Y
No comments:
Post a Comment