Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Minor
-
Resolution: Won't Fix
-
Affects Version/s: CMT8.4.1
-
Fix Version/s: CMT8.4.1.201209
-
Component/s: CUBRID Migration Toolkit
-
Labels:
-
Environment:
CMT2.0.0.5272
From oracle to cubrid
Description
1 Create one table in oracle
CREATE TABLE "TEST"."ATHLETE"
( "CODE1" NUMBER(*,0),
"NAME1" VARCHAR2(40) NOT NULL ENABLE,
"GENDER" CHAR(1),
"NATION_CODE" CHAR(3),
"EVENT" VARCHAR2(30),
CONSTRAINT "PK_ATHLETE_CODE" PRIMARY KEY ("CODE1")
USING INDEX 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" ENABLE
) 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" ;
CREATE UNIQUE INDEX "TEST"."PK_ATHLETE_CODE" ON "TEST"."ATHLETE" ("CODE1")
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" ;
ALTER TABLE "TEST"."ATHLETE" ADD CONSTRAINT "PK_ATHLETE_CODE" PRIMARY KEY ("CODE1")
USING INDEX 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" ENABLE
2 Do migration
Actual result:
The pk "PK_ATHLETE_CODE" became to "PK_ATHLETE_CODE1"
It doesn't matter.