jjzjj

Subpartition

全部标签

Exchange Table Subpartition With Data And Its All LOCAL Partition Indexes 子分区

YouhaveatablecalledTAB1whichisAUTOPARTITIONONADATECOLUMNandthenSUB-PARTITOINfurther.Nowyouaretryingtomovedataanditssub-partitionLOCALINDEXESfromTAB1toTAB3usingexchangepartition.YouhaveastagingtableasTAB2.AllthreetablesTAB1(maintable),TAB2(stagingtable)andTAB3(historytable)havesametablestructure.Nowt