A new enhancement in Oracle Database version 21c is saving a lot if effort in Data pump activities.
In the earlier versions of Oracle using the INCLUDE and EXCLUDE parameters in the data pump jobs would result in “UDE-00011: parameter include is incompatible with parameter exclude” error.
Not anymore !!!
Now with Oracle 21c it is possible to combine these parameters. This enables a lot of new and easier to use scenarios, for example:
Export/import all tables except one table of one or more schemas
Export/import all tables, but exclude indexes and statistics
Sample data pump expdp parfile with both INCLUDE & EXCLUDE Parameters,
USERID=username/password@TNSNAME
DIRECTORY=DATA_PUMP_DIR
DUMPFILE=expdp_tables.dmp
LOGFILE=expdp_tables.log
SCHEMAS=SCHEMA1, SCHEMA2
INCLUDE=TABLE
EXCLUDE=TABLE:”IN (‘TABLE1’, ‘TABLE2’)”
This will export all the objects in SCHEMA1 & SCHEMA2 but will not export the tables mentioned in the EXCLUDE parameters.
