« Kamus的主题演讲:数据库升级方法&案例分析 | Blog首页 | Oracle中审计删除(DELETE)操作的触发器 »
HP-UX平台的 EXPDP 转义符定义 FLASHBACK_TIME
作者:eygle | 【转载请注出处】|【云和恩墨 领先的zData数据库一体机 | zCloud PaaS云管平台 | SQM SQL审核平台 | ZDBM 数据库备份一体机】
链接:https://www.eygle.com/archives/2011/01/hp_ux_expdp_flashback_time.html
同事在HP-UX平台执行EXPDP导出时遇到错误,问我哪些转义符需要定义,导出命令大致是这样的:链接:https://www.eygle.com/archives/2011/01/hp_ux_expdp_flashback_time.html
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
历史上的今天...
>> 2014-01-10文章:
>> 2012-01-10文章:
>> 2008-01-10文章:
>> 2007-01-10文章:
>> 2006-01-10文章:
>> 2005-01-10文章:
By eygle on 2011-01-10 11:59 | Comments (2) | FAQ | 2695 |
孜孜不倦! :)
还是是用参数par文件吧