测试分区表部分导出

测试过程：

创新互联不只是一家网站建设的网络公司；我们对营销、技术、服务都有自己独特见解，公司采取“创意+综合+营销”一体化的方式为您提供更专业的服务！我们经历的每一步也许不一定是最完美的，但每一步都有值得深思的意义。我们珍视每一份信任，关注我们的成都做网站、成都网站建设、成都外贸网站建设质量和服务品质，在得到用户满意的同时，也能得到同行业的专业认可，能够为行业创新发展助力。未来将继续专注于技术创新，服务升级，满足企业一站式营销型网站需求，让再小的品牌网站制作也能产生价值！

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内容:

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

金华银行数据仓库分区表导出具体代码：

编写一个par文件：

expdp.par内容:

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

本文名称：测试分区表部分导出
分享网址：http://mswzjz.cn/article/psjeec.html