Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question

migrated from Aug 30 '12 at 0:49

This question came from our site for professional and enthusiast programmers.

What date/timestamp formats is Vertica expecting? Can you edit your question with an example, along with what methods you've tried to dump the data from Oracle? – Phil Aug 30 '12 at 14:50

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:

    ID NUMBER (10),
    NAME VARCHAR2 (50),

Assuming a compatible table structure on Vertica:

    ID BIGINT NOT NULL    /*ORACLE datatype: NUMBER(10, 0)  */,
    NAME VARCHAR(50)      /*ORACLE datatype: VARCHAR2(50)   */,
    ADDRESS VARCHAR(250)  /*ORACLE datatype: VARCHAR2(250)  */,

Load the table content using the copy command in Vertica:

copy "table name" from 'full csv file path'
    delimiter ',' null as '' exceptions 'full error file path';


share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.