I want to transfer data from Oracle to Vertica and I want to know what is best way to do it?
I s there a tool for it?
I tried to dump the Oracle data and load it to Vertica using 'Copy Direct
' command but I fount lots of problems specially in the data and timestamps columns.
Best Answer
Try to export the data into
csv
format, and recreate the table in Vertica using the DDL from Oracle. Check the types as they differ from Oracle to Vertica.Example: assuming the following table structure on Oracle:
Assuming a compatible table structure on Vertica:
Load the table content using the copy command in Vertica:
Done!