if i am deleted all data from particular range partition then should i delete that partition separately using delete partition command or it will deleted from database automatically due to no data available in that partition.?
if not delete that partition, will it consume space?
thx in advance.