windows下:
备份命令
osrexp -usysdba/szoscar55 -hlocalhost -p2003 -dosrdb level=schema file=D:\temp\t\exp log=D:\temp\t\bk_exp.log mode=entirety ignore=false schema=(jc6_dz) view=true sequence=true procedure=true constraint=true trigger=true index=true
恢复命令
osrimp -ujk_dz/jh0101 -hlocalhost -p2003 -dosrdb level=schema file=c:/20140328.osr log=c:/bk_imp.log mode=entirety ignore=true schema=(jk_dz) recreateschema=false view=true sequence=true procedure=true recreateotherobject=true recreatetable=true constraint=true deletetabledata=true trigger=true index=true
linux下:
备份命令
osrexp -ujk_dz/jh0101 -hlocalhost -p2003 -dosrdb level=schema file=/home/oscar/20140328.osr log=/home/oscar/bk_exp.log mode=entirety ignore=false schema=\(jc6_dz\) view=true sequence=true procedure=true constraint=true trigger=true index=true
恢复命令
osrimp -ujk_dz/jh0101 -hlocalhost -p2003 -dosrdb level=schema file=/home/oscar/20140328.osr log=/home/bk_imp.log mode=entirety ignore=true schema=\(jc6_dz\) recreateschema=false view=true sequence=true procedure=true recreateotherobject=true recreatetable=true constraint=true deletetabledata=true trigger=true index=true
备份命令
osrexp -usysdba/szoscar55 -hlocalhost -p2003 -dosrdb level=schema file=D:\temp\t\exp log=D:\temp\t\bk_exp.log mode=entirety ignore=false schema=(jc6_dz) view=true sequence=true procedure=true constraint=true trigger=true index=true
恢复命令
osrimp -ujk_dz/jh0101 -hlocalhost -p2003 -dosrdb level=schema file=c:/20140328.osr log=c:/bk_imp.log mode=entirety ignore=true schema=(jk_dz) recreateschema=false view=true sequence=true procedure=true recreateotherobject=true recreatetable=true constraint=true deletetabledata=true trigger=true index=true
linux下:
备份命令
osrexp -ujk_dz/jh0101 -hlocalhost -p2003 -dosrdb level=schema file=/home/oscar/20140328.osr log=/home/oscar/bk_exp.log mode=entirety ignore=false schema=\(jc6_dz\) view=true sequence=true procedure=true constraint=true trigger=true index=true
恢复命令
osrimp -ujk_dz/jh0101 -hlocalhost -p2003 -dosrdb level=schema file=/home/oscar/20140328.osr log=/home/bk_imp.log mode=entirety ignore=true schema=\(jc6_dz\) recreateschema=false view=true sequence=true procedure=true recreateotherobject=true recreatetable=true constraint=true deletetabledata=true trigger=true index=true