DMP文件大小约1TB导入690G时中断,打开表后查看无一条数据,在检查里多了一条已启用的,查看SQL有以下语句
impdp中断 ALTER TABLE "TB"."TB_8" DISABLE CONSTRAINT "SYS_C0010930"
*请问如何跳过重新导入跳过也行,继续执行也可以,
**
以下是导入时的日志
Import: Release 11.2.0.1.0 - Production on 星期四 11月 17 13:06:45 2022
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
已成功加载/卸载了主表 "TB"."SYS_IMPORT_TABLE_01"
启动 "TB"."SYS_IMPORT_TABLE_01": username/ directory=DATA_PUMP_DIR dumpfile=dmp_01.dmp,dmp_02.dmp tables=TB.TB_8 content=data_only table_exists_action=append parallel=10
处理对象类型 TABLE_EXPORT/TABLE/TABLE_DATA
KUP-11007: conversion error loading table "TB"."TB_8"
ORA-26093: input data column size (193) exceeds the maximum input size (22)
KUP-11009: data for row: PLACEOFDOMICILE : ''
作 业 "TB"."SYS_IMPORT_TABLE_01" 因致命错误于 13:49:47 停止