ORACLE 导入导出数据库命令

时间:2023-01-20 03:20:30
●1.导出数据库表语句。
exp dzjc/dzjc@orcl_127.0.0.1 tables=SYSDEPARTMENT file=c:\SYSDEPARTMENT.dmp buffer=40960
exp riseapprove/risenet@orcl tables=RISENET_EMPLOYEE file=c:\123.dmp buffer=40960
exp taicang/taicang@tcxm_10.35.0.91 tables=articleinfo file=c:\20071128_SPM_ApproveItem.dmp buffer=40960


●2.导入数据库表语句


imp taicang/taicang@tcxm_10.35.0.91 file=C:\2.dmp fromuser=taicang touser=taicang buffer=40960
imp taicang/taicang@tcxm_10.35.0.91 file=c:\20071128_SPM_ApproveItem.dmp fromuser=pukou touser=pukou buffer=40960
imp ycsunzw/sunzw@orcl file=C:\new\dzhc20100704.dmp fromuser=ycsunzw touser=ycsunzw buffer=40960


●3.导出整个数据库语句
exp frame/frame@oracle_192.168.1.101 file=c:\frame.dmp buffer=40960
exp dzjc/dzjc@orcl_32.176.63.12 file=e:\20091229.dmp buffer=40960
exp dzjc/dzjc@orcl_127.0.0.1 file=c:\ycdzjc.dmp buffer=40960
exp hangzhou/hangzhou@hzrf_172.16.0.229 file=f:\20091229.dmp buffer=40960
exp riseapprove/1@orcl_61.155.50.159 file=c:\20100223.dmp buffer=40960
exp system/ok@orcl file=e:\1003.dmp log=e:\1003.txt full=y
exp ycsunzw/sunzw@orcl file=c:\YC.dmp buffer=40960


●4.导入整个数据库语句
imp frame/frame@oracle_192.168.1.101 file=c:\frame.dmp fromuser=frame touser=frame buffer=40960
imp dzjc/dzjc@orcl_127.0.0.1 file=c:\1.dmp fromuser=dzjc touser=dzjc buffer=40960
imp dzjc/dzjc@orcl_32.176.63.19 file=c:\20100410DZJCDing.dmp fromuser=dzjc touser=dzjc buffer=40960
imp qlk/qlk file=e:\qlk.dmp fromuser=qlk touser=qlk buffer=40960
imp riseapprove/1@tcxm_10.35.0.91 file=d:\changshu0717.dmp fromuser=csxm touser=csxm buffer=40960
imp taicang/taicang@tcxm_10.35.0.91 file=c:\1105.dmp fromuser=lishuisp touser=lishuisp buffer=40960
imp riseapprove/risenet@orcl_32.176.63.17 file=c:\20100410Ding fromuser=riseapprove touser=riseapprove buffer=40960
imp dzjc/dzjc@orcl_32.176.63.19 file=c:\20100410DZJCDing.dmp fromuser=dzjc touser=dzjc buffer=40960
imp riseapprove/risenet@mastdb  file=C:\20100410Ding.dmp fromuser=riseapprove touser=riseapprove buffer=40960
imp dzjc/dzjc@orcl file=E:\20100410DZJCDing.dmp fromuser=dzjc touser=dzjc buffer=4096
imp riseapprove/1@orcl2 file=E:\20100410Ding.dmp fromuser=riseapprove touser=riseapprove buffer=40960