ORACLE - 10.1.0.2.0 - using exp ... TABLES=(A,B)

[Stephen Ray Badgett]

Hi,

Getting error "sh: Syntax error: `(' is not expected."

This will work on Linux but cannot seem to use the statement TABLES=(A,B) but not on HP-UX B.11.23 U ia64.

export rxuser=STEVE
export dbpw=

export now=`date +'%Y%m%d:%H:%M:%S'`


$ORACLE_HOME/bin/exp $dbuser/$dbpw STATISTICS=none TABLES=(DRG,CHCKTBL) log=/tmp/exp-table-original-TEST$now.log file=exp-table-original-TEST$now.dmp


Steve

[Stephen Ray Badgett]

I figured it out ...

$ORACLE_HOME/bin/exp $dbuser/$dbpw STATISTICS=none TABLES=(DRG,CHCKTBL) log=/tmp/exp-table-original-TEST$now.log file=exp-table-original-TEST$now.dmp

should be

$ORACLE_HOME/bin/exp $dbuser/$dbpw STATISTICS=none TABLES="DRG,CHCKTBL" log=/tmp/exp-table-original-TEST$now.log file=exp-table-original-TEST$now.dmp

[Stephen Ray Badgett]

I little more testing of syntax fixed it