Wednesday, December 23, 2009

Oracle schema backup and restore

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