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

Home -> Community -> Usenet -> c.d.o.server -> Alter Table help needed.

Alter Table help needed.

From: Rob Panosh <rob_panosh_at_asdsoftware.com>
Date: Thu, 20 Sep 2001 10:49:45 -0500
Message-ID: <1001000979.693353@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 - 10:49:45 CDT

Original text of this message

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