Any one know how to Data Transfer from Oracle to Vertica?
Can you please suggest me...
First,you can export to structure the file from Oracle,then import to Vertica by using 'copy'.
You can refer to this answer https://forum.vertica.com/discussion/232819/export-data-from-bd-oracle-to-vertica-in-less-time
In addition to that Qinchaofeng has already said, you can use any of the ETL product load data from Oracle to Vertica.
Here are the link for various document that we have published for Oracle Data Integrator, Pentaho, Informatica etc.https://www.vertica.com/documentation/vertica/technology-partner-integrations/
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.