Oracle备份还原

exp demo/demo@ORCL file=d:\demo.dmp
exp demo/demo@ORCL file=d:\demo.dmp owner=demo
exp demo/demo@ORCL buffer=40960000 file=demo.dmp full=y log=demo.log compress=n
exp demo/demo@192.168.1.23 file=e:\demo.dmp tables=demo.testtab1,demo.testtab12

imp demo/demo@ORCL fromuser=demo touser=demo file=d:\demo.dmp
imp demo/demo@ORCL fromuser=demo touser=demo_test file=d:demo.dmp ignore=y rows=y
imp demo/demo@192.168.1.23 fromuser=demo touser=demo file=e:\demo.dmp tables=testtab1,testtab2
imp demo/demo@192.168.1.23 fromuser=demo touser=demo file=e:\demo.dmp tables=testtab1 ignore=y

  1. da shang
    donate-alipay
               donate-weixin weixinpay

发表评论↓↓