Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: How to create an index / primary key after using SQL*Loader?
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
![]() |
![]() |