Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> 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