Oracle数据库备份还原

Oracle备份:

exp vta/vtaPwd@hrst file=F:BackUpdaochu.dmp log=F:BackUpdaochu.log owner=vta

Oracle恢复:
imp vta/vta@hrst file=E:Oraclevta20181111.dmp fromuser=vtahg touser=vta grants=n ignore=y statistics=none

fromuser=vtahg :原用户
touser=vta:目标用户
ignore忽略创建错误
grants导出权限
statistics分析对象(ESTIMATE)

如果在CMD中执行备份命令不成功,则先去到Oracle所在bin目录,再执行命令:

例如Oracle目录:F:Oracleproduct11.2.0dbhome_1BIN


详情参考:https://blog.csdn.net/q547550831/article/details/50074973

原文地址:https://www.cnblogs.com/tan80000/p/9953167.html