Oracle export with where clause and parallelism

This pretty much sums up the way to export tables with a where clause.

export DATA_PUMP_DIR="EXPORT_DIR"

expdp \'/ as sysdba\'  tables=scott.emp query=scott.emp:'"where eno <>0"' dumpfile=emp%U.dmp parallel=5 logfile=emp.log compression=all

parallelism is NOT mandatory and can be skipped

The above is put into a shell script and can be run from the unix prompt.
Tested only on UNIX systems.