any recommendations, documents, SOPs on how to migrate from vertica db to Oracle db?
Just to be clear, you're asking how to move FROM Vertica TO Oracle? Might want to post this question on an Oracle board. They'll know better than we would.
eddieKar, why you solved to migrate from Vertica to Oracle?