expdp（impdp）中的特殊字符转义

密码转义

expdp aa/"""abcdf$@#$Q41"""@orcl 

expdp 'ultranms/"Ultra@Nms"' 

expdp "/ as sysdba" 

expdp  \'\/ as sysdba\'' 

expdp '/ as sysdba' 

这些都是针对密码的转义

query转义

query=DH.IERP_WO_SN_USER:\" where creation_date\>"'23-SEP-15'"\",DH.WIP_SN_COLLECTION_INFO:\" where creation_date\>"'23-SEP-15'"\"

这里还是建议使用parfile

下面是个是用parfile的例子，结合密码转义

vi param.par

DIRECTORY=DIR
PARALLEL=4
DUMPFILE=FULL_%U.DMP
LOGFILE=FULL.LOG
SCHEMAS=USER1,USER2
EXCLUDE=TABLE:"IN ('USER1.TAB1','USER2.TAB2')"
QUERY=USER1.TAB3:"where a='3'",USER2.TAB3:"where a>to_date(sysdate,'yyyy-mm-dd hh24:mi:ss')"

命令

expdp  \'\/ as sysdba\''  parfile=param.par