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:
-nameexpr TABLE:"NOT IN (‘CONTACTS’,’COUNTRIES’,’CUSTOMERS’)"
see documentation here.