利用exp/imp變換普通表為分割槽表_10g_windows

  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

sqlplus

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;