数据泵-EXCLUDE+QUERY

EXCLUDE=TABLE:\"IN\(\'TTT\'\)\"

EXCLUDE=SEQUENCE,VIEW                          
  
EXCLUDE=TABLE:"IN ('EMP','DEPT')"              
  
EXCLUDE=SEQUENCE,VIEW,TABLE:"IN ('EMP','DEPT')" 
  
EXCLUDE=INDEX:"= 'INDX_NAME'"                   -
  
EXCLUDE=PROCEDURE:"LIKE 'PROC_U%'"       
  
INCLUDE=TABLE:"> 'E' "                

其它常用操作符 NOT IN, NOT LIKE, <, != 等等

EXCLUDE=TABLE:\"IN\(\'TTT\',\'T1_SAFE\'\)\"

EXCLUDE=TABLE:\"IN\(\'TTT\',\'T1_SAFE\'\)\"

EXCLUDE=TABLE:\"LIKE\'T_PLATFORM%\'\"

 EXCLUDE=TABLE:\"LIKE\'T_PLATFORM%\'\"

 

 

 query=scott.emp:'"where deptno=20"',scott.dept:'"where deptno=20"'