常用expdp脚本

只导表结构

expdp gdsdc/gdsdc dumpfile=gdsdc1227.dmp logfile=gdsdc1227.log directory=IMPDPDATA job_name=gdsdc_job CONTENT=METADATA_ONLY SCHEMAS=gdsdc exclude=STATISTICS

 

导出schema部分特征表不导出

expdp gdsdc/gdsdc dumpfile=gdsdc_meta.dmp logfile=gdsdc_meta.log directory=IMPDPDATA job_name=gdsdcmeta_job SCHEMAS=gdsdc exclude=STATISTICS,TABLE:\"LIKE\'F_%\'\",TABLE:\"LIKE\'I_%\'\",TABLE:\"LIKE\'D_%\'\",TABLE:\"LIKE\'L_%\'\"

 

导出部分特征表排除部分表

expdp gdsdc/gdsdc dumpfile=gdsdc_d.dmp logfile=gdsdc_d.log directory=IMPDPDATA job_name=gdsdcd_job TABLES=D_% exclude=STATISTICS,TABLE:\"IN \(\'D_NW_NE_HOTSPOT\',\'D_CUSTBAK0926\',\'D_CUST\'\)\"

 

导出部分特征表的特征partition

expdp gdsdc/gdsdc dumpfile=gdsdc_dd.dmp logfile=gdsdc_dd.log directory=IMPDPDATA job_name=gdsdcdd_job TABLES=GDSDC.F_%_D  exclude=STATISTICS,TABLE_DATA:\"IN \(select partition_name from dba_tab_partitions where table_owner=\'GDSDC\' and table_name like \'F_%_D\' and partition_name not like \'P_20131226%\'\)\",TABLE:\"IN \(\'F_NW_NE_PM_CUST_UTRANCELL_TB_D\',\'F_NW_NE_PM_CUST_BUSI_TB_D\',\'F_DCUST_MN_COUNT_D\',\'F_SGSN_D\',\'F_SGSN_TB_D\',\'F_NW_NE_PM_MN_CUST_CELL_D\',\'F_NW_NE_PM_CUST_BUSI_D\',\'F_NW_NE_PM_MN_CUST_CELL_TB_D\'\)\" 

 

expdp gdsdc/gdsdc dumpfile=gdsdc_fh.dmp logfile=gdsdc_fh.log directory=IMPDPDATA job_name=gdsdcfh_job TABLES=GDSDC.F_%_H exclude=STATISTICS,TABLE_DATA:\"IN \(select partition_name from dba_tab_partitions where table_owner=\'GDSDC\' and table_name like \'F_%_H\' and partition_name not like \'P_20131227%\'\)\",TABLE:\"IN \(\'FC_CS_MM_CELL_H\',\'F_DQ_DATASOURCE_FN_H\',\'F_SGSN_H\',\'F_CS_MM_CELL_H\'\)\"  

 

expdp gdsdc/gdsdc dumpfile=gdsdc_ih.dmp logfile=gdsdc_ih.log directory=IMPDPDATA job_name=gdsdcih_job TABLES=GDSDC.I_%_H exclude=STATISTICS,TABLE_DATA:\"IN \(select partition_name from dba_tab_partitions where table_owner=\'GDSDC\' and table_name like \'I_%_H\' and partition_name not like \'P_20131227%\'\)\",TABLE:\"IN \(\'I_PS_GDS03_2G_CELL_SP_H\',\'I_NW_NE_PM_CELL_H\',\'I_DCUST_MN_COUNT_H\',\'I_CS_MM_CELL_H\',\'I_CUST_MN_H\',\'I_SGSN_H\'\)\"

 

expdp gdsignal/gdSignal%NSN123 dumpfile=mm_cell8.dmp logfile=mm_cell.log directory=DATA_PUMP_DIR job_name=mm_cell_job TABLES=gdsignal.I_CS_MM_CELL_H exclude=STATISTICS,TABLE_DATA:\"IN \(select partition_name from dba_tab_partitions where table_owner=\'GDSIGNAL\' and table_name like \'I_CS_MM_CELL_H\' and partition_name not like \'P_201402110800%\'\)\" compression=DATA_ONLY