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.
+2Hi ,
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
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
