SqlDbx Forum

garbuya

Member

Bug in CREATE script for partitioned tables

When CREATE script generates DDL for a partitioned table it does not correctly generates CREATE INDEX

Original index

create index ix1 on tbl1(col1)
NOLOGGING LOCAL
(partition part1 pctfree 10 initrans 2 maxtrans 255 NOLOGGING storage(...) tablespace tsp1
,partition part2 pctfree 10 initrans 2 maxtrans 255 NOLOGGING storage(...) tablespace tsp2
...
,partition part9 pctfree 10 initrans 2 maxtrans 255 NOLOGGING storage(...) tablespace tsp9
)
PARALLEL 8 ;

Generated index

create index ix1 on tbl1(col1) tablespace tsp1 initial 20480 next 61440;

As you can see, script generated GLOBAL index instead of LOCAL one and this is a big difference!
Also, this index is LOGGING NOPARALLEL, i.e. directly opposite then original index.

Last edited by garbuya (2018-01-10 12:33:05)