測試過程：

創(chuàng)新互聯(lián)不只是一家網(wǎng)站建設(shè)的網(wǎng)絡(luò)公司；我們對營銷、技術(shù)、服務(wù)都有自己獨特見解，公司采取“創(chuàng)意+綜合+營銷”一體化的方式為您提供更專業(yè)的服務(wù)！我們經(jīng)歷的每一步也許不一定是最完美的，但每一步都有值得深思的意義。我們珍視每一份信任，關(guān)注我們的成都做網(wǎng)站、成都網(wǎng)站建設(shè)、成都外貿(mào)網(wǎng)站建設(shè)質(zhì)量和服務(wù)品質(zhì)，在得到用戶滿意的同時，也能得到同行業(yè)的專業(yè)認可，能夠為行業(yè)創(chuàng)新發(fā)展助力。未來將繼續(xù)專注于技術(shù)創(chuàng)新，服務(wù)升級，滿足企業(yè)一站式營銷型網(wǎng)站需求，讓再小的品牌網(wǎng)站制作也能產(chǎn)生價值！

expdp user/pass directory=dump4dev tables=PDATA.PC_INV dumpfile=PDATA.PC_INV.dmp logfile=PDATA.PC_INV.log query='PDATA.PC_INV:"where data_date>=20140707 and data_date<=20140708"'

create table test(

t_date varchar2(10),

t_num number(10)

)

partition by list (t_date)

(partition p_20160220 values ('20160220'),

partition p_20160221 values ('20160221'),

partition p_20160222 values ('20160222'),

partition p_20160223 values ('20160223'),

partition p_20160224 values ('20160224'),

partition p_20160225 values ('20160225'),

partition p_20160226 values ('20160226'),

partition p_20160227 values ('20160227'),

partition p_20160228 values ('20160228'),

partition p_20160229 values ('20160229'),

partition p_20160301 values ('20160301'),

partition p_20160302 values ('20160302'),

partition p_20160303 values ('20160303')

);

insert into test values('20160220',1);

insert into test values('20160221',2);

insert into test values('20160222',3);

insert into test values('20160223',4);

insert into test values('20160224',5);

insert into test values('20160225',6);

insert into test values('20160226',7);

insert into test values('20160227',8);

insert into test values('20160228',9);

insert into test values('20160229',10);

insert into test values('20160301',11);

insert into test values('20160302',12);

insert into test values('20160303',12);

select name,COLUMN_NAME from dba_PART_KEY_COLUMNS where name='TEST';

SELECT TABLE_NAME,PARTITION_NAME FROM dba_tab_partitions WHERE TABLE_NAME='TEST';

select * from test partition(P_20160222);

expdp.par內(nèi)容:

DIRECTORY=DUMPDIR

DUMPFILE=test.dmp

LOGFILE=test.log

TABLE=SCOTT.TEST

INCLUDE=TABLE_DATA:"IN (select partition_name from dba_tab_partitions where table_name in ('TEST') and substr(partition_name,3,8) < '20160301')"

expdp system/oracle parfile=/server/soft/expdp.par

expdp system/oracle directory=DUMPDIR dumpfile=test.dmp logfile=test.log EXCLUDE=TABLE_DATA:"IN (select partition_name from dba_tab_partitions where table_name in ('TEST') and substr(partition_name, 3, 8) < '20160301')"

P20160312

金華銀行數(shù)據(jù)倉庫分區(qū)表導出具體代碼：

編寫一個par文件：

expdp.par內(nèi)容:

DIRECTORY=DUMPDIR

DUMPFILE=test.dmp

LOGFILE=test.log

TABLE=SCOTT.TEST

EXCLUDE=TABLE_DATA:"IN (select partition_name from dba_tab_partitions where table_name in ('TEST') and substr(partition_name,2,8) < '20150101')"

expdp system/oracle parfile=/server/soft/expdp.par