oracle分区表备份,只还原1个分区

2016-06-06

oracle分区表备份,只还原1个分区,使用statistics=none,也就是不导出统计信息。

alter table ANONYMOUSUSER_ALL truncate partition ANONY_ALL_2011_05 update indexes;
imp part/part file=ANONYMOUSUSER_ALL-ANONY_ALL_2011_05.dmp tables=ANONYMOUSUSER_ALL:ANONY_ALL_2011_05 ignore=y
备份多个分区:
exp part/part file=ANONY_ALL_2011_07-ANONY_ALL_2011_08.dmp tables=ANONYMOUSUSER_ALL:ANONY_ALL_2011_07,ANONYMOUSUSER_ALL:ANONY_ALL_2011_08  statistics=none

创建分区表:
create table 1
{}

导入多个分区:

imp part/part file=ANONY_ALL_2011_07-ANONY_ALL_2011_08.dmp tables=ANONYMOUSUSER_ALL:ANONY_ALL_2011_07,ANONYMOUSUSER_ALL:ANONY_ALL_2011_08 ignore=y
imp talk99_crm/comeontalk99 file=/opt/crm_contact_2016-05-30-05.dmp tables=CRM_CONTACT:PT_10029768 ignore=y buffer=102400000

select count(*) from crm_contact partition(PT_10029768) where CREATOR='btqjljguodan';
IMP-00032: SQL statement exceeded buffer length
解决办法:
SQL语句超过缓冲区长度,需要加大buffer,可以指定buffer的大小.

分类:数据库 | 标签: |

相关日志

评论被关闭!