测试分区表部分导出

发布时间:2020-08-11 11:42:34 作者:yingyifeng306
阅读:166
开发者专用服务器限时活动,0元免费领! 查看>>

测试过程:

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

亿速云「云服务器」,即开即用、新一代英特尔至强铂金CPU、三副本存储NVMe SSD云盘,价格低至29元/月。点击查看>>

推荐阅读:
  1. 企业实践用户邮箱导入/导出(第2部分)
  2. 分区表部分分区导出到其他实例

开发者交流群:

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。

原文链接:http://blog.itpub.net/23732248/viewspace-2285227/

分区表 导出 测试

上一篇:Linux查看占用内存的进程脚本

下一篇:ERP软件可以为企业发展带来4大优势

相关阅读

您好,登录后才能下订单哦!

密码登录
登录注册
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》
开发者交流群×