Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Alter Table help needed.
alter table emp
add (constraint blah_pk primary key (empno)
deferrable initially immediate
using index
tablespace indx01);
Regards
HJR
"Rob Panosh" <rob_panosh_at_asdsoftware.com> wrote in message
news:1001000979.693353_at_nntp.accessus.net...
> Hi,
>
> My sample alter statement:
> --------------------------
> ALTER TABLE myTable
> ADD CONSTRAINT PK_MYTABLE PRIMARY KEY (myTestColumn)
> /
>
>
> Could somebody please revise the above demonstrating how to store this
> primary key in a different table space than the table? I need an example
on
> how to set phyical options.
>
>
> Thanks,
> --
> Rob Panosh
> Advanced Software Designs
>
>
>
>
>
Received on Thu Sep 20 2001 - 13:34:54 CDT