I am aware of creating partitions and defining partitions on tables but not sure what actully happens at back when we drop a partition?
I heard all the rows from dropped partion will moved to save table? Is that statement correct? if not what will happen to the existing partition data?
Can someone provide me some more info on that?
You need to take precautions with insert into by knowing your data. Know your data well, how it is placed.The link below explains: