Tags

, , , ,

Oracle Datapump – Using expdp utility excluding table & table partitions in a par file can be managed with the below syntax…

–Excluding Table Partitions’ Data

EXCLUDE=TABLE_DATA:”IN (select partition_name from dba_tab_partitions where table_name in (‘TABLE_NAME1’,’TABLE_NAME2’…) and partition_name like ‘%_P%’ and substr(partition_name,-4,4) < to_char(sysdate,’YYYY’) and partition_name not like ‘%P2013%’)” –P20XX

–Excluding Table

EXCLUDE=TABLE:”IN (‘TABLE_NAME1’,’TABLE_NAME2’…)”

 

Advertisements