When using the EXCLUDE parameter in expdp, I assume it evaluates at start of the process, and so will not find the datapump tables SYS_EXPORT_SCHEMA_% to be able to exclude them.
Is there a way to exclude the datapump tables from the extract? I was looking at EXCLUDE=TABLE:"IN(select table_name from dba_tables where table_name like 'SYS_EXPORT_SCHEMA_%')" but if that is evaluated at the start of the process, the tables will not exist.
Thanks in anticipation.