copy blob columns of a table from oracle to vertica

anujanuj
in General Discussion

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.

Comments

  • eli_revacheli_revach

    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
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...