eygle Eygle.
FAQ 2011-01-10

HP-UX平台的 EXPDP 转义符定义 FLASHBACK_TIME

同事在HP-UX平台执行EXPDP导出时遇到错误,问我哪些转义符需要定义,导出命令大致是这样的:
HP> expdp eygle SCHEMAS=eygle DIRECTORY=data_pump_dir DUMPFILE=eygle.dmp FLASHBACK_TIME=\"TO_TIMESTAMP('31-12-2010 11:30:30', 'DD-MM-YYYY HH24:MI:SS')\"
Badly placed ()'s.

这里只转义双引号还不够,括号也是特殊字符,需要转义:
 expdp eygle/eygle DIRECTORY=data_pump_dir FLASHBACK_TIME=\"TO_TIMESTAMP\('31-12-2010 11:30:30', 'DD-MM-YYYY HH24:MI:SS'\)\"

Export: Release 10.2.0.1.0 - 64bit Production on Friday, 31 December, 2010 12:22:13
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning and Data Mining options
记录备忘。


By eygle 2011-01-10 11:59 评论 (2)
eygle
eygle

前Oracle ACE Director,云和恩墨创始人。技术为骨,历史为脉,人文为魂。

返回首页

2 Comments

孜孜不倦! :)

还是是用参数par文件吧