有些哥们喜欢用sys用户来做expdp、impdp的工作,这里不讨论合理性,只简单说下注意事项:
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