Jump to Navigation

182 - Oracle exp bash: syntax error near unexpected token

When you excute the following Oracle Export command under Linux bash.

# exp user_id/password file=./tables.dmp tables=(table_a,table_b,table_c,table_d)

You could get the error :

bash: syntax error near unexpected token `('

Correct syntax is :

# exp user_id/password file=./tables.dmp "tables=(table_a,table_b,table_c,table_d)"

You need the doble quotation for the tables parameter.

 

Oracle:


Main menu 2

Story | by Dr. Radut