| 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
![]()  | 
![]()  |