本文档详细记录了在使用Oracle数据泵工具expdp时遇到的ORA-29913和ORA-01722错误的详细情况及解决过程。在问题描述部分，阐述了错误发生的具体场景；在问题解决部分，给出了排查和修复这些问题的步骤和方法。
一. 问题描述：
[oracle@crfdb1 temp]$ expdp clspuser/clsp dumpfile=hmtdb20130301_hmt_log.dmp directory= pump_dir tables = crf_p2p_rpt_bill_pen_new query=crf_p2p_rpt_bill_pen_new:'"where ( GZ_YM = '2016-08' or GZ_YM ='2016-09' or GZ_YM ='2016-10')"'
Export: Release![]()
10.2.0.1.0 - 64bit Production on Tuesday, 08 November, 2016 15:26:00
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release![]()
10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Starting "CLSPUSER"."SYS_EXPORT_TABLE_01": clspuser/******** dumpfile=hmtdb20130301_hmt_log.dmp directory= pump_dir tables = crf_p2p_rpt_bill_pen_new query=crf_p2p_rpt_bill_pen_new:"where ( GZ_YM = 2016-08 or GZ_YM &#
Export: Release
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release
With the Partitioning, OLAP and Data Mining options
Starting "CLSPUSER"."SYS_EXPORT_TABLE_01": clspuser/******** dumpfile=hmtdb20130301_hmt_log.dmp directory= pump_dir tables = crf_p2p_rpt_bill_pen_new query=crf_p2p_rpt_bill_pen_new:"where ( GZ_YM = 2016-08 or GZ_YM &#
最低0.47元/天 解锁文章
867
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
