ant 配置expdp and impap
+
执行步骤:
ant -f 1_exp_prod.xml
copy file from prod to uat (maunule)
ant -f 3_imp_uat.xml
附件:
1.1_exp_prod.xml
<?xml version="1.0" encoding="UTF-8"?>
<project name="DBHandler" basedir="." default="exp">
<target name="exp">
<exec executable="cmd.exe">
<arg line="/c expdp system/oracle123@t1prod file=t1prod2016128_%U.dmp directory=XMLDIR log=t1prod20161122_152621.log tables=('t1data.event','t1data.eventRp','t1data.tblSign','t1data.tblLeave','t1data.daytime','t1data.day') parallel=4"/>
</exec>
</target>
</project>
2. copy_to_uat.xml
<?xml version="1.0" encoding="UTF-8"?> -<project default="copy" basedir="." name="DBHandler"> -<target name="copy"> -<exec executable="cmd.exe"> <arg line="/c copy D:\app\Administrator\product\11.2.0\dbhome_1\rdbms\xml\t1prod20161122_152621_2.dmp to 192.168.63.19:C:\app\Administrator\product\11.2.0\dbhome_1\rdbms\xml/> </exec> </target> </project>
3.3_imp_uat.xml
<?xml version="1.0" encoding="UTF-8"?>
<project name="DBHandler" basedir="." default="imp">
<target name="imp">
<exec executable="cmd.exe">
<arg line="/c impdp system/oracle123@t1uat file=t1prod2016128_%U.dmp directory=XMLDIR log=TS_all_imp_2016_09_02.log table_exists_action=replace remap_schema=t1data:t1data parallel=4"/>
</exec>
</target>
</project>
相关文章
- mongodb or and 条件拼凑 Query.And Query.Or
- Asp.Net配置Web.Config更改默认上传文件大小限制!(适用于win7win2003的IIS)
- 04dwr - web.xml配置(常用 init-param 参数列表)
- Maven mirrorOf配置
- SpringBoot配置https
- 1.DHCP服务器的配置
- HCIP第十一天——BGP基本配置,发布路由,路由聚合,路由反射器
- DRF 3.x Request and Response 请求和响应使用示例和配置方法
- linux 服务器(CentOS7)搭建PHP环境+SSH配置+服务器文件上传配置
- jenkins配置从git指定分支下载代码,打包部署jar包
- linux下安装nginx和配置
- 配置Tomcat的JVM的大小解决Tomcat内存溢出的问题
- Elasticsearch之IK分词器配置
- webpack高级概念,typeScript的打包配置(系列十三)
- 小贴士:正确估算而非过度配置公共云资源