Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Create index via ALTER TABLE command

Re: Create index via ALTER TABLE command

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 23 Jun 2005 07:44:27 -0700
Message-ID: <1119537867.273196.60190@g43g2000cwa.googlegroups.com>


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)

   using index
   tablespace IDXSPC
   pctfree 05
   initrans 04
   maxtrans 08
   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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US