oracle基础备份和还原

#全库备份
exp mminfo/123456 buffer=64000 inctype=complete file=c:\mminfo.dmp log=c:\mminfo.log

#用户备份：用户mminfo下的所有表
exp mminfo/123456 buffer=64000  owner=mminfo file=c:\mminfo.dmp log=c:\mminfo.log

#表备份：备份用户(mminfo)下的单个表(t_unit)
exp mminfo/123456 buffer=64000  tables=(mminfo.t_unit) file=c:\mminfo.dmp log=c:\mminfo.log


#全库还原-存在同样的表需要删除
imp mminfo/123456 buffer=64000 full=y file=c:\mminfo.dmp log=c:\mminfo.log fromuser=mminfo touser=mminfo_bak

#用户还原：用户mminfo下的所有表 -存在同样的表需要删除
imp mminfo/123456 buffer=64000 ignore=y file=c:\mminfo.dmp log=c:\mminfo.log fromuser=mminfo touser=mminfo_bak

#表还原：还原用户(mminfo)下的单个表(t_unit) -存在同样的表需要删除
imp mminfo/123456 buffer=64000 ignore=y tables=(t_unit) file=c:\mminfo.dmp log=c:\mminfo.log fromuser=mminfo touser=mminfo_bak

 

转载于:https://www.cnblogs.com/zhangpengshou/p/5034780.html