Re: creating an index with dba studio?

You are aware you specified (according to the command below) a next extent of *1K*!!
Also unlimited will translate to some number equal to 2 to the power of 32 - 1.

Regards,

Sybrand Bakker, Oracle DBA

"Carsten Jacobs" <carsten.jacobs_at_tool42.com> wrote in message news:3A224641.36451AEF_at_tool42.com...
>
> Hello,
>
> I was going to create an index with SQL Studio
> I clicked everythig I needed for that index and then clicked the show
> sql button.
> I copied the sql statement and run the statement in sql plus.
>
> CREATE INDEX "SAR"."SDSTIME_IDX" ON "SAR"."PRODUCT"("TIMEABSOLUTESRV")
> TABLESPACE "SAR_INDEX"
> PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE
> ( INITIAL 20M NEXT 1K MINEXTENTS 1 MAXEXTENTS UNLIMITED FREELISTS 1
> FREELIST GROUPS 1) NOLOGGING
>
> When the index was created, I looked again in SQL Studio but the
> maxextend field of the created index
> is not set to unlimited and the next extend size is 0 instead of 1 MB.
>
> Is there any explanation for this behaviour?
>
> Thanks for any help.
>
> Carsten
Received on Mon Nov 27 2000 - 05:41:41 CST