We are working on a task to migrate oracle database to vertica. Need suggestion in coverting the packages or stored procedures from oracle to vertica. Do we have any feature to use for this in Verica.
Oracle packages are not supported by Vertica while Oracle stored procedures could basically be converted to Vertica external procedures. You might best be off redesigning your Oracle code in terms of UDF's which translate straightforwardly to Vertica UDF's.