For Oracle11G EXPDP
应要求到某个表的某个月之间的数据
EXPDP HELP=Y
QUERY
于是 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')"
于是要加转移符号
]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\'\)\"
不是吧 转移那么多!!