Re: Sql Question regarding Primary Keys and Using Index

btolar_at_fedworld.gov (Bryant) wrote in message news:<b0bb806d.0109191051.4a488527_at_posting.google.com>...
> When creating a new table we usually specify the location we would
> like the index to be placed
>
> Create Table Junk(
> test varchar2(5) constraint junk_test_pk primary key
> using index
> tablespace junkidx01
> storage (initial 80k
> next 80k),
> key number(5))
> tablespace junkdata01
> storage (initial 1M
> next 1M);
>
> What do you do if you want columns test and key to make up the primary
> key and you still want to specify where the index resides?

Never mind looks like the easiest way to do it is create the table without a primary key then use an alter table statement with the storage information.

Thanks anyway
B Received on Wed Sep 19 2001 - 16:01:24 CDT