Can anyone tell me if i can use not in clause in partition , I want to delete all the partitions except one,
alter table <tablename> drop partition(partion_name<>partition_val) doesnt work.
Thanks for your response, however i need know if drop partition not in clause exist, may be my example is confusing .
I have partitions like
load_id='F' and i want to drop all but partitions D&E
Sorry for the looooooooong delay in response, currently there is no way i guess except listing all partitions that need to be removed manually .
but it would be cool to have "drop partition not in "option when there are huge number of partitions to be purged