General
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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
2 REPLIES

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

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

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

I little more testing of syntax fixed it