Any one know how to Data Transfer from Oracle to Vertica?
Can you please suggest me...
You can use an ETL tool, see here a list of tools.
Or you can do it by scripts.
- depending on the number of tables you want ot exports this might give you some work , but can be automated.