暂无图片
Windows下使用数据泵导出按照多个表多个条件脚本怎么写exp
我来答
分享
墨竹
2021-04-09
Windows下使用数据泵导出按照多个表多个条件脚本怎么写exp

Windows下使用数据泵导出按照多个表多个条件脚本怎么写exp,query加where条件可以加and吗,两个表两个时间用to_date转换,总是提示不能多个值

我来答
添加附件
收藏
分享
问题补充
1条回答
默认
最新
你好我是李白

Windows跟Linux一样啊,写个parfile呗,可以写AND,例如:

$ cat expdp_query.par 
QUERY=employees:"WHERE department_id > 10 AND salary > 10000",test:"WHERE ID > 100 AND ID < 10000"
TABLES=employees,test

$ expdp hr/hr directory=expdp parfile=expdp_query.par dumpfile=hr_query.dmp
Export: Release 11.2.0.4.0 - Production on Fri Apr 9 09:59:02 2021

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Starting "HR"."SYS_EXPORT_TABLE_01":  hr/******** directory=expdp parfile=expdp_query.par dumpfile=hr_query.dmp 
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 23.06 MB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TABLE_EXPORT/TABLE/COMMENT
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/TRIGGER
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "HR"."TEST"                                 188.9 KB    9898 rows
. . exported "HR"."EMPLOYEES"                            10.33 KB      15 rows
Master table "HR"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for HR.SYS_EXPORT_TABLE_01 is:
  /rman/expdp/hr_query.dmp
Job "HR"."SYS_EXPORT_TABLE_01" successfully completed at Fri Apr 9 09:59:13 2021 elapsed 0 00:00:11
暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏