- 导入
导入指定用户
imp userName/password@orcl file=C:\sd.dmp fromuser=oldUser touser=newUser ignore = y;
- 导出
导出 指定用户下的表
exp uesrname/password@orcl file=d:\daochu.dmp owner=username grants=n
imp userName/password@orcl file=C:\sd.dmp fromuser=oldUser touser=newUser ignore = y;
exp uesrname/password@orcl file=d:\daochu.dmp owner=username grants=n