Windows:单引号
expdp 'sys/change_on_install@instance as sysdba' tables=scott.emp
Unix or Linux (you need to 'escape' the single quote):转义符加单引号
expdp \'sys/change_on_install@instance as sysdba \' tables=scott.emp
VMS (use [double_quote][single_quote]...[single_quote][double_quote]):双引号加单引号
expdp "'sys/change_on_install@instance as sysdba'" tables=scott.emp
--------------------------------------------------------------------------------
eg:
sys的密码无特殊符号:
expdp \'sys/manager1 AS SYSDBA\'
expdp \'sys/oracle AS SYSDBA\' schemas=system directory=DATA_PUMP_DIR dumpfile=system_%U.dmp parallel=2 job_name=jobexpdpimpdp consistent=y
sys的密码有特殊符号:
expdp \'sys/"manager.1" AS SYSDBA\'
expdp \'sys/"oracle.1" AS SYSDBA\' schemas=system directory=DATA_PUMP_DIR dumpfile=system_%U.dmp parallel=2 job_name=jobexpdpimpdp consistent=y
