Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

copy blob columns of a table from oracle to vertica

I need to copy data from my oracle database to vertica.


Some oracle tables has BLOB datatypes. Please let me know how these tables can be copied.


For tables that do not have BLOB/CLOB, i can spool/write data to flat files and load it in vertica.


I need help for BLOB data type columns.


  • Hi ,

    The only way i see is using code , Eg : java code which extract each blob to separate file + the metadata of the blob , like its id and etc , on the other side , you need a code that read the metadata + the blob file and load it to vertica table .

    I hope you will find it useful Thanks

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.