Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Index organized table
On 29.03.2005 18:16 Mark D Powell wrote:
> Checking the 9.2 SQL manual CREATE TABLE syntax it does not appear that
> the syntax supports explicit naming of the Indexed Organized Table
> index until you look at the out of line constraint attribute clause:
>
> UT1 > create table marktest2 (
> 2 fld1 varchar2(10)
> 3 ,fld2 varchar2(10)
> 4 ,fld3 number
> 5 ,constraint marktest2_pk primary key (fld1)
> 6 )
> 7 organization index
> 8 tablespace dataspc
> 9 pctfree 10
> 10 storage (initial 16K next 16k pctincrease 0 maxextents 32)
> 11 /
>
Cool!
Works like a charm (even with 8.1.7, forgot to mention that in the intial posting). Didn't think of naming the PK in the constraint clause.
Thanks for your help
Thomas Received on Wed Mar 30 2005 - 01:25:50 CST