标题: How to add partition primary key to partition table? [打印本页] 作者: pearaep 时间: 2003-05-13 12:04 标题: How to add partition primary key to partition table? I want to recreate normal table to partition tables for the data is very large. But I can't create or add partition primary key to a partition table. My table have only ONE column as PK and the partition key is defferent from index column. I add PK dierectly to the table but it's not partitioned. I only find so little meterial about it in metalink, and the meterial cant resole the problem. Pls help me.
Thanks!作者: yikaikai 时间: 2003-05-13 14:17 标题: How to add partition primary key to partition table? create table test
(col1 number,col2 number, col3 varchar2(10))
partition by range (col1)
(partition part1 values less than (5000) tablespace users,
partition part2 values less than (10000) tablespace system);
alter table test
add (constraint test_pk primary key (col1)
using index local
(partition test_ind1 tablespace users,
partition test_ind2 tablespace system));
try it作者: pearaep 时间: 2003-05-13 15:18 标题: How to add partition primary key to partition table? meet error 14039. Btw, my table's partition key is defferent from primary key.作者: pearaep 时间: 2003-05-13 15:34 标题: How to add partition primary key to partition table? reslove it. but should create pk using two columns.