DATA PUMP: EXCLUDE / INCLUDE TABLE IMPORT

EXCLUDING TABLES DURING DATA_PUMP IMPORT:

impdp USERNAME/PASSWORD schemas=USERNAME directory=DIRECTORY_NAME dumpfile=FILE_NAME.dmp EXCLUDE=TABLE:\"IN \(\'TABLE1\',\'TABLE2\',\'TABLE3\',\'TABLE4\',\'TABLE5\',\'TABLE6\'\)\"

impdp ultimus/ultimus schemas=ultimus directory=db_back dumpfile=AFT_EOD.dmp EXCLUDE=TABLE:\"IN \(\'IMG_SIGNATORY_IMAGE\',\'IMG_SIGNATORY_IMAGE_DEL_LOG\',\'IMG_SIGNATORY_INFO\',\'IMG_SIGNATORY_VERIFY_LOG\',\'IMG_BACH_CLG_HIST_IN\',\'IMG_BRM_INST\',\'IMG_NFT_AUTH_LOG\'\)\"


EXCLUDING TABLES DURING DATA_PUMP IMPORT - USING  "LIKE "  COMMAND:

impdp USERNAME/PASSWORD schemas=USERNAME directory=DIRECTORY_NAME dumpfile=FILE_NAME.dmp EXCLUDE=TABLE:\"like 'IMG_%%'\" EXCLUDE=TABLE:\"IN \(\'EMP\',\'DEPT\'\)\"

INCLUDING TABLES DURING DATA_PUMP IMPORT:

impdp USERNAME/PASSWORD schemas=USERNAME directory=DIRECTORY_NAME dumpfile=FILE_NAME.dmp INCLUDE=TABLE:\"IN \(\’EMP\’, \’DEP\’\)\"

The OLD Subquery TRICK:


EXCLUDE :
expdp directory=DB_BACK dumpfile=zakir.dmp EXCLUDE=table:\"in \(select table_name from all_tables where table_name like \'IMG_%\' or table_name like \'%HIST%\'\)\"



INCLUDE :
expdp directory=DB_BACK dumpfile=zakir.dmp INCLUDE=table:\"in \(select table_name from all_tables where table_name like \'IMG_%\' or table_name like \'%HIST%\'\)\"




thanks for reading this article.

------------------------------------------------------------------------------------------
Happy to Help!