在linux執行exp指令報錯,如下:
[oracle]$ exp system/****@orasid file=/home/oracle/dump/exp.dmp owner=(a,b,c,d) log=/home/oracle/dump/exp_a_b_c_d.log buffer=102400000
-bash: syntax error near unexpected token `('
經查是linux系統執行指令的小括号需要轉義,改成如下指令,正常執行
[oracle]$ exp system/****@orasid file=/home/oracle/dump/exp.dmp owner="(a,b,c,d)" log=/home/oracle/dump/exp_a_b_c_d.log buffer=102400000
也可以在小括号前加 \ 轉義:
[oracle]$ exp system/****@orasid file=/home/oracle/dump/exp.dmp owner=\(a,b,c,d\) log=/home/oracle/dump/exp_a_b_c_d.log buffer=102400000
參考網址:https://blog.csdn.net/feng2147685/article/details/85238775