sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sharma, Aniruddh" <Aniruddh.Sha...@cibc.com>
Subject how to bring BLOB from Oracle
Date Wed, 09 May 2018 16:29:49 GMT

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.


View raw message