Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

create index with high initrans

1932140Sep 27 2017 — edited Sep 27 2017

Hi

I'm trying to create a unique index with INITRANS 100, but I get a syntax error. Can somebody help ?

create unique index pk_new_order on new_order (no_w_id, no_d_id, no_o_id)

tablespace users PCTFREE 40, PCTUSED 50 , INITTRANS 100

storage (INITIAL 100K  NEXT  50K  MINEXTENTS 1  MAXEXTENTS 50  PCTINCREASE 5);
This post has been answered by Solomon Yakobson on Sep 27 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 25 2017
Added on Sep 27 2017
4 comments
1,729 views