Créer un index partitionné

Posted by DiabloCorps on 12 octobre 2010 Leave a comment (0) Go to comments 
CREATE INDEX matable_part ON matable(colonne)
GLOBAL PARTITION BY RANGE (colonne)(
PARTITION part_1 VALUES LESS THAN (100000)
, PARTITION part_2 VALUES LESS THAN (2000000)
, PARTITION part_max VALUES LESS THAN (MAXVALUE)  )
Oracle, ,

Laisser un commentaire