How to exclude tables during import using impdp 


grant dba to labserp identified by labserp;

CREATE TABLESPACE LABSERP_TS
   DATAFILE 'LABSERP_TS.dbf'
    SIZE 100M
    REUSE
    AUTOEXTEND ON NEXT 10M ;

CREATE OR REPLACE DIRECTORY test_dir1 AS 'E:\personal\';

GRANT READ, WRITE ON DIRECTORY test_dir1 TO labserp;

impdp labserp/labserp  exclude=TABLE:\"IN (\'DO_AUDIT_DETAIL\', \'PR_DAY_WISE_ATTENDENCE_040720\', \'PR_DAY_WISE_ATTENDENCE_070720\', \'PR_DAY_WISE_ATTENDENCE_090720\', \'PR_DAY_WISE_ATTENDENCE_07073PM\', \'AC_DATA_LOG_BK\')\" directory=TEST_DIR1 dumpfile=expdp_28-07-Tue_23.00_PM.dmp logfile=impdpEMP_DEPT.log