Partitioned index issue

bantonuk

Source database 11.2.0.3
OS Oracle Linux 5.x

actual index in the database is defined as

CREATE INDEX "MRD_BUCKET1"."TEST_HASH_BUCKET_IDX" ON "MRD_BUCKET1"."MRD_NAMES" ("HASH_BUCKET_VALUE", "LASTNAME_FIRST_LETTER", "ENTITY_SEQ")
PCTFREE 10 INITRANS 20 MAXTRANS 255 NOLOGGING
STORAGE(
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "MRD_BUCKET1_DATA" GLOBAL PARTITION BY RANGE ("HASH_BUCKET_VALUE")
(PARTITION "P_0" VALUES LESS THAN (1) TABLESPACE "MRD_BUCKET1_DATA_PART_01" ,
PARTITION "P_1" VALUES LESS THAN (2) TABLESPACE "MRD_BUCKET1_DATA_PART_02" ,
PARTITION "P_2" VALUES LESS THAN (3) TABLESPACE "MRD_BUCKET1_DATA_PART_03" ,
PARTITION "P_3" VALUES LESS THAN (4) TABLESPACE "MRD_BUCKET1_DATA_PART_04" ,
PARTITION "P_4" VALUES LESS THAN (5) TABLESPACE "MRD_BUCKET1_DATA_PART_05" ,
PARTITION "P_5" VALUES LESS THAN (6) TABLESPACE "MRD_BUCKET1_DATA_PART_06" ,
PARTITION "P_6" VALUES LESS THAN (7) TABLESPACE "MRD_BUCKET1_DATA_PART_07" ,
PARTITION "P_7" VALUES LESS THAN (8) TABLESPACE "MRD_BUCKET1_DATA_PART_08" ,
PARTITION "P_8" VALUES LESS THAN (9) TABLESPACE "MRD_BUCKET1_DATA_PART_09" ,
PARTITION "P_ELSE" VALUES LESS THAN (MAXVALUE) TABLESPACE "MRD_BUCKET1_DATA_PART_10" );

but when i pull it out via the tool ...i get this

CREATE INDEX mrd_bucket1.test_hash_bucket_idx ON mrd_bucket1.mrd_names(hash_bucket_value,lastname_first_letter,entity_seq)
PARALLEL;

all the partition information is gone

Michael Christofides

Hi,

Thank you for getting in touch, it seems our support team have since also been in touch, but there is also a request on our public UserVoice forum for this, for anybody else who finds this thread:

https://redgate.uservoice.com/forums/17 ... se-storage

Best regards,
Michael Christofides

Product Manager