Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: CMT8.4.1, CMT8.4.1.201203
-
Fix Version/s: CMT8.4.1.201205
-
Component/s: CUBRID Migration Toolkit
-
Labels:None
-
Environment:
CMT2.0.0.5236
From oracle to cubrid (offline mode)
Description
1 create one table
CREATE TABLE "TEST"."BLOB_TYPE"
( "ID" NUMBER(*,0),
"BLOB1" BLOB
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS"
LOB ("BLOB1") STORE AS (
TABLESPACE "USERS" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10
NOCACHE
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)) ;
CREATE UNIQUE INDEX "TEST"."SYS_IL0000030204C00002$$" ON "TEST"."BLOB_TYPE" (
PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS"
PARALLEL (DEGREE 0 INSTANCES 0) ;
2 Add some data(include picture, txt,htm)
3 Do migration from oracle to cubrid
Actual result
The data hasn't been migrated.
Using loaddb command to load rows which contain blob/clob is not working very well.