Skip to Main Content

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!

"using index" clause in add constraint (primary key) statement

suman amaraMay 19 2014 — edited May 19 2014

HI Team,

i have some query about Alter Table.

what is the use of USING INDEX ? explan about the STORAGE process in ?

ALTER TABLE COMMAND   ADD CONSTRAINT CPM_N_PK PRIMARY KEY (CMD_SEQ) 

USING INDEX   TABLESPACE &1

PCTFREE 10  

INITRANS 2  

MAXTRANS 255  

STORAGE   (    

     INITIAL 97664K    

     NEXT 1M    

    MINEXTENTS 1    

MAXEXTENTS UNLIMITED   ) ;

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 16 2014
Added on May 19 2014
3 comments
3,531 views