测试过程: expdp user/pass directory=dump4dev tables=PDATA.PC_INV dumpfile=PDATA.PC_INV.dmp logfile=
测试过程:
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
--结束END--
本文标题: 测试分区表部分导出
本文链接: https://www.lsjlt.com/news/48581.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
2024-10-23
2024-10-22
2024-10-22
2024-10-22
2024-10-22
2024-10-22
2024-10-22
2024-10-22
2024-10-22
2024-10-22
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0