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

Home -> Community -> Usenet -> c.d.o.tools -> Re: How to create an index / primary key after using SQL*Loader?

Re: How to create an index / primary key after using SQL*Loader?

From: Mike <ihatespam_at_ihatespam.com>
Date: Mon, 11 Jun 2001 23:29:43 GMT
Message-ID: <HvcV6.4727$Il5.578922@newsread1.prod.itd.earthlink.net>

alter table xxx add constraint pk_xxx
primary key (col1);

"susie grace" <hlng_at_usa.net> wrote in message news:7eecf32f.0106111503.59b9fafc_at_posting.google.com...
> I mass load a table using the direct load method in SQL*Loader, but now
> wish to set up an index and primary key.
>
> Can someone provide sample syntax of how to do so?
>
> Thanks.
Received on Mon Jun 11 2001 - 18:29:43 CDT

Original text of this message

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