--导出数据
本地 exp system/zhd@zhd252 owner=gy,jgjs,tz,pf,ls,cs,cms file=C:\系统迁移\fxgc20121128.dmp log=c:\fxgc_exp.log
远程 exp system/zhd@10.2.31.240/spaq owner=gy,jgjs,tz,pf,ls,cs,cms file=C:\系统迁移\fxgc20121128.dmp log=c:\fxgc_exp.log
exp system/zhd@zhd252 owner=cms file=C:\系统迁移\fxgc20121128.dmp log=c:\fxgc_exp.log
imp system/qwer1234@fxgc153 file=C:\系统迁移\fxgc20121128.dmp fromuser=gy,jgjs,tz,pf,ls,cs,cms touser=gy,jgjs,tz,pf,ls,cs,cms buffer=409600 feedback=10000 log=c:\fxgc_imp.log
imp system/qwer1234@fxgc153 file=C:\系统迁移\fxgc20121128.dmp fromuser=cms touser=cms buffer=409600 feedback=10000 log=c:\fxgc_imp.log
--测试库
imp system/qwer1234@spaq file=C:\系统迁移\fxgc20121128.dmp fromuser=gy,jgjs,tz,pf,ls,cs,cms touser=gy,jgjs,tz,pf,ls,cs,cms buffer=409600 feedback=10000 log=c:\fxgc_spaq_imp.log
exp system/qwer1234@orcl owner=gy,jgjs,tz,pf,ls,cs,cms file=C:\系统迁移\fxgc153_20121212.dmp log=c:\fxgc_exp_20121212.log
imp system/qwer1234@orcl file=C:\系统迁移\fxgc153_20121212.dmp fromuser=gy,pf,ls,cs touser=gy,pf,ls,cs buffer=409600 feedback=10000 log=c:\fxgc_spaq_imp.log
imp system/qwer1234@orcl file=C:\系统迁移\fxr_20121212.dmp fromuser=gy,jgjs,tz,pf,ls,cs,cms touser=gy,jgjs,tz,pf,ls,cs,cms buffer=409600 feedback=10000 log=c:\系统迁移\fxgc_orcl_imp.log
--linux系统导出
exp system/oracle_2011_system@fxr1 owner=gy,jgjs,tz,pf,ls,cs,cms file=/oracle/fxr_20121212.dmp
scp /oracle/fxr_20121212.dmp root@192.168.0.151:/usr/local/tomcat/webapps/fxr_20121212.dmp
scp /oracle/fxr_20121212.tar.gz root@192.168.0.151:/usr/local/tomcat/webapps/fxr_20121212.tar.gz
imp system/qwer1234@orcl file=C:\系统迁移\fxr_20121212.dmp fromuser=cms touser=cms1 buffer=409600 feedback=10000 log=c:\fxgc_cms1_imp.log
exp system/oracle_2011_system@fxr1 owner=gy,jgjs,tz,pf,ls,cs,cms file=/oracle/fxgc20130401.dmp
imp system/qwer1234@orcl file=C:\系统迁移\fxgc20130401.dmp fromuser=gy,jgjs,tz,pf,ls,cs,cms touser=gy,jgjs,tz,pf,ls,cs,cms buffer=409600 feedback=10000 log=c:\系统迁移\fxgc_orcl_imp.log