Incidentally, if you want to do storage clauses and such like, stick that
between the 'using index' clause and the 'tablespace indx01' line.
Cheers
HJR
"Howard J. Rogers" <howardjr_at_www.com> wrote in message
news:3baa361d_at_news.iprimus.com.au...
> 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:37:47 CDT
