You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@sqoop.apache.org by "Sharma, Aniruddh" <An...@cibc.com> on 2018/05/09 16:29:49 UTC

how to bring BLOB from Oracle

Hi

Oracle can store BLOB data


  1.  Inline (size of data stored is less than 4000 bytes)
  2.  Inline (size of data stored is greater than 4000 bytes) - hence data is actually stored as out of line.
  3.  Out of line storage (where only pointer is stored ) but actual content is stored outside in a BFILE or in a separate table namespace.


How to generate Sqoop query to tackle both inline and out-of-line storage.

Thanks
Aniruddh