Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Create index via ALTER TABLE command
Jens, Sybrands comment about adding an index using an alter table
statement is valid only for the PK constraint should be interpreted to
also include UK constraints.
See the SQL manual
alter table oooooooo.tttttttt
add constraint tttttttt_PK
primary key (sample_column2,
sample_column1)
storage (initial 16k next 16k maxextents 32 pctincrease 0);
If you have not done so then I suggest before working with Oracle that you read the Concepts manual. It is the single best place to start when learning about the Oracle rdbms.
HTH -- Mark D Powell -- Received on Thu Jun 23 2005 - 09:44:27 CDT