oracle创建主键开并行,Oracle并行添加主键

2.考虑先并行添加惟一性索引，再添加主键

SQL> create unique index pk_t on t(object_id) parallel 2 online; Index created

SQL> alter table t add constraint pk_t primary key (object_id); Table altered

SQL> alter index pk_t noparallel; Index altered

3.对比主键和惟一性索引的区别

SQL> desc t

Name Type Nullable Default Comments -------------- ------------- -------- ------- -------- OWNER VARCHAR2(30) Y

OBJECT_NAME VARCHAR2(128) Y

SUBOBJECT_NAME VARCHAR2(30) Y

OBJECT_ID NUMBER

DATA_OBJECT_ID NUMBER Y

OBJECT_TYPE VARCHAR2(19) Y

CREATED DATE Y

LAST_DDL_TIME DATE Y

TIMESTAMP VARCHAR2(19) Y

STATUS VARCHAR2(7) Y

TEMPORARY VARCHAR2(1) Y

GENERATED VARCHAR2(1) Y

SECONDARY VARCHAR2(1) Y

NAMESPACE NUMBER Y

EDITION_NAME VARCHAR2(30) Y

SQL> alter table t drop primary key; Table altered

S