注册

部分表迁移时,表空间迁移错误,迁移到了MAIN空间中

初心 2024/06/12 460 5 已解决

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:dm8
【操作系统】:centos7
【CPU】:x86
【问题描述】*:部分表迁移时,使用的表空间存在问题,迁移到了MAIN空间中,有些表时正确的。是不是ddl语句中有些和达梦中不兼容,导致后面指定的表空间失效,进而使用默认表空间MAIN?

源oracle表ddl:
-- RSMDATA.ALL_BRANCH_INFO definition

CREATE TABLE "RSMDATA"."ALL_BRANCH_INFO"
( "BRANCH_CODE" VARCHAR2(10) NOT NULL ENABLE,
"BRANCH_FULL_NAME" VARCHAR2(100) NOT NULL ENABLE,
"BRANCH_NAME" VARCHAR2(60) NOT NULL ENABLE,
"BRANCH_ADDRESS" VARCHAR2(300) NOT NULL ENABLE,
"SERVICE_ADDRESS" VARCHAR2(300) NOT NULL ENABLE,
"PHONE" VARCHAR2(30) NOT NULL ENABLE,
"SERVICE_PHONE" VARCHAR2(30) NOT NULL ENABLE,
"FAX" VARCHAR2(18),
"POSTCODE" VARCHAR2(6) NOT NULL ENABLE,
"EMAIL" VARCHAR2(100),
"BRANCH_SETUP_DATE" DATE NOT NULL ENABLE,
"BRANCH_CLOSE_DATE" DATE,
"BRANCH_LEVEL" VARCHAR2(2) NOT NULL ENABLE,
"PARENT_BRANCH" VARCHAR2(10),
"BRANCH_CHIEF" VARCHAR2(100) NOT NULL ENABLE,
"BIZ_LICENSE_NO" VARCHAR2(20),
"BIZ_LICENSE_NAME" VARCHAR2(300),
"IS_HEADQUARTER" VARCHAR2(1) NOT NULL ENABLE,
"COMPANY_TYPE" VARCHAR2(2) NOT NULL ENABLE,
"COUNTRY_CODE" VARCHAR2(3) NOT NULL ENABLE,
"PROVINCE_CODE" VARCHAR2(6) NOT NULL ENABLE,
"CITY_CODE" VARCHAR2(6) NOT NULL ENABLE,
"AREA_CODE" VARCHAR2(6),
"PK_SERIAL" VARCHAR2(20) NOT NULL ENABLE,
"IS_VALID" VARCHAR2(1) NOT NULL ENABLE,
"CREATED_USER" VARCHAR2(100) NOT NULL ENABLE,
"CREATED_DATE" DATE NOT NULL ENABLE,
"UPDATED_USER" VARCHAR2(100) NOT NULL ENABLE,
"UPDATED_DATE" DATE NOT NULL ENABLE,
"BRANCH_CLASS" VARCHAR2(2),
"CIRC_BRANCH_CODE" VARCHAR2(30),
CONSTRAINT "PK_ALL_BRANCH_INFO" PRIMARY KEY ("BRANCH_CODE")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RSMTBS" ENABLE,
CONSTRAINT "CK_ALL_BRANCH_INFO_IS_VALID" CHECK (IS_VALID in ('Y','N')) ENABLE
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 1048576 NEXT 8192 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RSMTBS" ;

CREATE UNIQUE INDEX "RSMDATA"."PK_ALL_BRANCH_INFO" ON "RSMDATA"."ALL_BRANCH_INFO" ("BRANCH_CODE")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RSMTBS" ;

GRANT UPDATE ON "RSMDATA"."ALL_BRANCH_INFO" TO "DEPLOYOP";
GRANT SELECT ON "RSMDATA"."ALL_BRANCH_INFO" TO "DEPLOYOP";
GRANT INSERT ON "RSMDATA"."ALL_BRANCH_INFO" TO "DEPLOYOP";
GRANT DELETE ON "RSMDATA"."ALL_BRANCH_INFO" TO "DEPLOYOP";
GRANT UPDATE ON "RSMDATA"."ALL_BRANCH_INFO" TO "MSACDE";
GRANT UPDATE ON "RSMDATA"."ALL_BRANCH_INFO" TO "MSAOPR";
GRANT SELECT ON "RSMDATA"."ALL_BRANCH_INFO" TO "MSACDE";
GRANT SELECT ON "RSMDATA"."ALL_BRANCH_INFO" TO "MSAOPR";
GRANT INSERT ON "RSMDATA"."ALL_BRANCH_INFO" TO "MSACDE";
GRANT INSERT ON "RSMDATA"."ALL_BRANCH_INFO" TO "MSAOPR";
GRANT UPDATE ON "RSMDATA"."ALL_BRANCH_INFO" TO "RSMTRIG";
GRANT UPDATE ON "RSMDATA"."ALL_BRANCH_INFO" TO "RSMCDE";
GRANT UPDATE ON "RSMDATA"."ALL_BRANCH_INFO" TO "RSMOPR";
GRANT SELECT ON "RSMDATA"."ALL_BRANCH_INFO" TO "RSMTRIG";
GRANT SELECT ON "RSMDATA"."ALL_BRANCH_INFO" TO "RSMCDE";
GRANT SELECT ON "RSMDATA"."ALL_BRANCH_INFO" TO "RSMOPR";
GRANT INSERT ON "RSMDATA"."ALL_BRANCH_INFO" TO "RSMTRIG";
GRANT INSERT ON "RSMDATA"."ALL_BRANCH_INFO" TO "RSMCDE";
GRANT INSERT ON "RSMDATA"."ALL_BRANCH_INFO" TO "RSMOPR";

回答 0
暂无回答
扫一扫
联系客服