Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How to partition primary key in create table script?
After I partition my table, I found that both lob column and data is partitioned, but not primary key. I am wondering how to partition primary key in my create table script? Below is my script. Thanks.
CREATE TABLE test
(
id NUMBER(10), name VARCHAR2(10) output CLOB, CONSTRAINT pk_test PRIMARY KEY (id) PCTFREE 10 STORAGE (...)
PARTITION test_p2 TABLESPACE ts_test_p2, PARTITION test_p3 TABLESPACE ts_test_p3, PARTITION test_p4 TABLESPACE ts_test_p4); Received on Wed Jul 18 2001 - 13:40:10 CDT