create table t(id number,name varchar2(10),stamptime date)
partition by range(stamptime)
(
partition part_t_20110505 values less than (to_date('20110505','yyyymmdd')),
partition part_t_20110506 values less than (to_date('20110506','yyyymmdd'))
);
insert into t values(1,'aa',trunc(sysdate)-1);
insert into t values(2,'bb',trunc(sysdate)-1);
insert into t values(3,'cc',trunc(sysdate)-1);
insert into t values(4,'dd',trunc(sysdate)-1);
commit;
用exp将数据导出后,改变表结构
create table t(id number,name varchar2(10),stamptime date)
partition by range(stamptime)
(
partition part_t_20110505 values less than (to_date('20110505','yyyymmdd'))
);
然后imp将刚导出的数据导入,会报错:要导入的数据找不到相应分区。
11g中可以解决这个问题:
create table t(id number,name varchar2(10),stamptime date)
INTERVAL( NUMTODSINTERVAL(1,'DAY'))
partition by range(stamptime)
(
partition part_t_20110505 values less than (to_date('20110505','yyyymmdd'))
);
这样用imp导入数据的时候,oracle会判断当前导入数据是否有可用分区,如果没有,会将导入文件里的分区和
数据一起导入数据库。
[@more@]
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24496749/viewspace-1049525/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24496749/viewspace-1049525/