dp oracle 11g,LRM-00116: ')' followed by 'yyyy-mm-dd' FOR ORACLE 11G EXPDP

For Oracle11G EXPDP应要求到某个表的某个月之间的数据EXPDP HELP=YQUERYPredicate clause used to export a subset of a table.For example, QUERY=employees:"WHERE department_id > 10".于是 expdp shark/2013 directory=dir_d..

嵌入式随笔

881人浏览 · 2021-04-15 21:40:37

嵌入式随笔 · 2021-04-15 21:40:37 发布

For Oracle11G EXPDP

应要求到某个表的某个月之间的数据

EXPDP HELP=Y

QUERY

Predicate clause used to export a subset of a table.

For example, QUERY=employees:"WHERE department_id > 10".

于是 expdp shark/2013 directory=dir_dp dumpfile =traderecord.dmp query=traderecord:"where tr_datetime >= to_date(‘2014-03-01‘,‘yyyy-mm-dd‘) and tr_datetime < to_date(‘2014-04-01‘,‘yyyy-mm-dd‘)"

LRM-00116: syntax error at ‘)‘ following ‘yyyy-mm-dd‘

于是要加转移符号

]expdp shark/2013 directory=dir_dp dumpfile =traderecord.dmp query=traderecord:\"where tr_datetime \>= to_date\(\‘2014-03-01\‘\,\‘yyyy-mm-dd\‘\) and tr_datetime \< to_date\(\‘2014-04-01\‘,\‘yyyy-mm-dd\‘\)\"

Export: Release 11.2.0.1.0 - Production on Tue Apr 1 14:30:47 2014

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Starting "CCPS"."SYS_EXPORT_SCHEMA_01": shark/******** directory=dir_dp dumpfile=traderecord.dmp query=traderecord:"where tr_datetime >= to_date(‘2014-03-01‘,‘yyyy-mm-dd‘) and tr_datetime < to_date(‘2014-04-01‘,‘yyyy-mm-dd‘)"

Estimate in progress using BLOCKS method...

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 10.92 GB

不是吧转移那么多!!

原文：http://blog.csdn.net/zengmuansha/article/details/22731963

魔乐社区

魔乐社区（Modelers.cn) 是一个中立、公益的人工智能社区，提供人工智能工具、模型、数据的托管、展示与应用协同服务，为人工智能开发及爱好者搭建开放的学习交流平台。社区通过理事会方式运作，由全产业链共同建设、共同运营、共同享有，推动国产AI生态繁荣发展。

更多推荐