DATAPUMP use of INCLUDE AND EXCLUDE Parameters simultaneously
in 19c is it possible to use include and exclude in the par file? i want to do
INCLUDE: TABLE:"LIKE 'EM_%'" but also EXCLUDE: TABLE:"LIKE 'EM_SUPPORTING_DOC%'"
is this possible ( i know it is in 21c) and if not, can anyone think of an INCLUDE that would cover both scenarios?
i tried several things but keeps saying badly formed. this query gets exactly what i want to get:
select * from DBA_OBJECTS where OWNER='<schema>' and OBJECT_TYPE='TABLE' and OBJECT_NAME like 'EM_%' and OBJECT_NAME not like 'EM_SUPPORTING_DOCUMENT%'
INCLUDE: TABLE:"LIKE 'EM_%'" but also EXCLUDE: TABLE:"LIKE 'EM_SUPPORTING_DOC%'"
is this possible ( i know it is in 21c) and if not, can anyone think of an INCLUDE that would cover both scenarios?
i tried several things but keeps saying badly formed. this query gets exactly what i want to get:
select * from DBA_OBJECTS where OWNER='<schema>' and OBJECT_TYPE='TABLE' and OBJECT_NAME like 'EM_%' and OBJECT_NAME not like 'EM_SUPPORTING_DOCUMENT%'
0