ewong74_at_netscape.net wrote:
>
> Hi there,
>
> How can I create a table on default tablespace but specifiy the primary key
> column, which is also an unique index, to build on another tablespace?
>
> Thank you.
>
> Ed
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
alter table my_table
add constraint my_prim_key
primary key ( col1, col2 )
using index
tablespace my_other_tspace;
--
Connor McDonald
BHP Information Technology
Perth, Western Australia
"Never wrestle a pig - you both get dirty and the pig likes it..."
Received on Thu Apr 08 1999 - 21:18:02 CDT
