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 ;
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