exp userid=old/system tables=normal file=c:\normal.dmp

imp userid=old/system tables=normal ignore=y (前提为你已经构建了分区hash表)

file=c:\normal.dmp log=c:\translate.log

select table_name,partition_name from user_tab_partitions;

注:如果你构建分区表时为显式指定分区名,oracle自命名为:sys_pn

附上:构建分区表

create table normal_partition(a int,b int)

partition by hash(a)

(partition p1,

partition p2);

或者

create table normal_partition(a int,b int)

partition by hash(a)

partitions 3;

添加分区

alter table normal_partition add partition p4;

ITPub博客

利用exp/imp变换普通表为分区表_10g_windows