测试分区表部分导出
测试过程:
创新互联不只是一家网站建设的网络公司;我们对营销、技术、服务都有自己独特见解,公司采取“创意+综合+营销”一体化的方式为您提供更专业的服务!我们经历的每一步也许不一定是最完美的,但每一步都有值得深思的意义。我们珍视每一份信任,关注我们的成都做网站、成都网站建设、成都外贸网站建设质量和服务品质,在得到用户满意的同时,也能得到同行业的专业认可,能够为行业创新发展助力。未来将继续专注于技术创新,服务升级,满足企业一站式营销型网站需求,让再小的品牌网站制作也能产生价值!
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://myzitong.com/article/psjeec.html