exp命令报错:-bash: syntax error near unexpected token `(‘

    技术2022-07-16  64

    在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

    Processed: 0.011, SQL: 10