exclude table in sqlcl datapump

I was trying to use datapump feature of sqlcl tool to export all tables from a schema, but it was not easy to find the solution to exclude a table in contrast to old expdp tool.

So while in old expdp tool, the parameter can be filled like this: EXCLUDE=TABLE:”IN (‘CONTACTS’,’COUNTRIES’,’CUSTOMERS’)” 

with sqlcl the parameters for exclusion do only allow object-types, one can get the same exclusion by table name using the nameexpr param and the NOT IN relational operator:


see documentation here.