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