How to Migrate DB2 BLOB to Oracle

What is BLOB/LOB/DBCLOB?

A large object is a data type used by DB2 to manage unstructured data. DB2 provides three built-in data types for storing large objects

Creating BLOB Table space:

Ref:Craig mullins article.

Example:

CREATE LOB TABLESPACE TDORGCHT
IN DSN8D10A
LOG NO
USING STOGROUP DB2NNN
PRIQTY 144000
SECQTY 144000
LOCKSIZE LOB
LOCKMAX 0
BUFFERPOOL BP47
DSSIZE 64 G
GBPCACHE SYSTEM;
COMMIT;
CREATE AUXILIARY TABLE DEPT_ORGCHART_TAB
IN DSN8D10A. TDORGCHT
STORES DSN81010.DEPT
COLUMN DEPT_ORG_CHART;COMMIT;

LOB(Large object data) will be stored in different format. We will have LOB locator in Auxilary table.

BLOB is a datatype of the column. In Both Oracle and DB2 the datatypes are the same. Check fo details.