#!/usr/bin/bash
.
.
.

/export/home/app/oracle/product/10.2.0/bin/exp $uname/$passw
    FILE="$WORKSPACE"/"$EXP_FILE"
    LOG="$EXP_LOG"
    TABLES=SYSTEM_PARAMETERS
    CONSISTENT=Y
    ROWS=Y
    INDEXES=Y
    CONSTRAINTS=Y
    GRANTS=Y ;

/export/home/app/oracle/admin/ukediuat/exp >./exp_syspar.sh
Username: USER
Enter DPDADMIN Password:

LRM-00116: syntax error at 'TABLES' following '='

EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help
EXP-00000: Export terminated unsuccessfully

TABLES='SYSTEM_PARAMETERS'

$ exp tables=system.plan_table file=plan_table.dmp statistics=none

Export: Release 11.2.0.2.0 - Production on Tue Feb 17 08:59:05 2015

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.


Username: system
Password:

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in UTF8 character set and AL16UTF16 NCHAR character set
server uses WE8MSWIN1252 character set (possible charset conversion)

About to export specified tables via Conventional Path ...
. . exporting table                     PLAN_TABLE          4 rows exported
Export terminated successfully without warnings.

#!/usr/bin/bash

TABLES=$DBUser."TBLTACCOUNTHISTORY"
directory=DATA_PUMP_DIR
dumpfile="ABC.dmp"
logfile="ABC.log"

expdp $SysDBUser/$SysDBPassword directory=$directory dumpfile=$dumpfile logfile=$logfile tables=$TABLES