用system用户导出,导入时也用system
三个用户名分别为user1,user2,user3
导出:
exp system/passwd file=myexp.dmp log=myexp.log owner='user1','user2','user3'
导入:
imp system/passwd file=myexp.dmp log=myimp.log fromuser='user1' touser='user1'
imp system/passwd file=myexp.dmp log=myimp.log fromuser='user2','user1' touser='user2','user1'
全部导出
imp {username}/{password}@{ip}:1521/{服务名} file=c:/a.dmp full=y
