Migrating DB2 BLOB to Oracle (1 of 2)

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.

About these ads