注册

恢复时无法删除现有表数据或者表重新插入数据

Days 2025/10/30 235 5 已解决

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:7.6
【操作系统】:Ubuntu
【CPU】:intel
【问题描述】*:

这是导入的日志
root@cc60001fb4e8:/opt/dmdbms/bin# cd /opt/dmdbms/bin/ && /opt/dmdbms/bin/dimp USERID=REPORT_TEST/123456789@192.168.169.133:5236 FILE=REPORT_TEST-20251030144714-2EBD4078.dmp DIRECTORY=/root/ LOG=REPORT_TEST-20251030144714-2EBD4078_import.log SCHEMAS=REPORT_TEST TABLE_EXISTS_ACTION=REPLACE IGNORE=Y
dimp V7.6.1.108-Build(2021.06.30-142705-10017)ENT

local code: PG_GB18030, dump file code: PG_UTF8

start importing schema[REPORT_TEST]...

start importing the NECESSARY GLOBAL objects of the schema...

finish importing the NECESSARY GLOBAL objects of the schema...

----- [2025-10-30 14:47:39]import table:TABLE_1 -----

[WARNING]Error Code:-6602,Violate unique constraint on [TABLE_1]

[WARNING]Error Code:-6602,Violate unique constraint on [TABLE_1]

[WARNING]Error Code:-6602,Violate unique constraint on [TABLE_1]

[WARNING]Error Code:-6602,Violate unique constraint on [TABLE_1]

import table TABLE_1 , has coped with 4 rows

[WARNING]import table TABLE_1 fail...

start importing the GLOBAL objects of the schema...

finish importing the GLOBAL objects of the schema...

import schema[REPORT_TEST] finish...

all the import process spent total 0.025 s

terminate import success with warning

这是测试的表结构
CREATE TABLE "REPORT_TEST"."TABLE_1"
(
"ID" CHAR(10) NOT NULL,
"COLUMN_2" CHAR(10),
"COLUMN_3" CHAR(10),
"COLUMN_4" CHAR(10),
"COLUMN_5" CHAR(10),
"COLUMN_6" CHAR(10),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;

库中只有这一个表 里面有4,5条数据

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