当前位置： 文江博客话题详情

Oracle：ORA-14400错误，将数据导入Excel中时

发布于 2025-02-12 03:18:22 字数 14241 浏览 2 评论 0原文

我正在尝试将数据从CSV文件中导入到表中，列名相同，并且数据类型匹配。当我尝试导入时，我会遇到以下错误。

ddl：

    CREATE TABLE "HR"."USER_PARTITION" 
       (    "SERIAL_ID" NUMBER, 
        "ACCOUNT_GUID" VARCHAR2(18 CHAR), 
        "MEMBER_ACCESS_LEVEL" VARCHAR2(80 CHAR), 
        "USER_GUID" VARCHAR2(18 CHAR), 
        "ACCOUNT_ACCESS_LEVEL" VARCHAR2(40 CHAR), 
        "SHARE_ACCOUNT_GUID" VARCHAR2(18 CHAR), 
        "CASE_ACCESS_LEVEL" VARCHAR2(40 CHAR), 
        "OPPORTUNITY_ACCESS_LEVEL" VARCHAR2(40 CHAR), 
        "USER_GROUP_GUID" VARCHAR2(18 CHAR), 
        "STATUS" VARCHAR2(20 CHAR), 
        "TEAM_MEMBER_ROLE_NAME" VARCHAR2(180 CHAR), 
        "COUNTRY_CODE" VARCHAR2(60 CHAR), 
        "REGION" NUMBER, 
        "ACCOUNT_ID" NUMBER, 
        "BADGE_NUMBER" VARCHAR2(18 CHAR), 
        "CREATION_DATE" DATE DEFAULT NULL, 
        "PROCESS_FLAG" VARCHAR2(1 BYTE) DEFAULT 'N', 
        "REC_INSERT_DATE" DATE
       ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
      STORAGE(
      BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
      TABLESPACE "SC_DATA01" 
      PARTITION BY RANGE ("REGION") 
      SUBPARTITION BY LIST ("PROCESS_FLAG") 
(PARTITION "P_REGION1"  VALUES LESS THAN (2) 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 ( SUBPARTITION "P_REGION1_Y"  VALUES ('Y') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS , 
  SUBPARTITION "P_REGION1_N"  VALUES ('N') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS ) , 
 PARTITION "P_REGION2"  VALUES LESS THAN (3) 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 ( SUBPARTITION "P_REGION2_Y"  VALUES ('Y') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS , 
  SUBPARTITION "P_REGION2_N"  VALUES ('N') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS ) , 
 PARTITION "P_REGION3"  VALUES LESS THAN (4) 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 ( SUBPARTITION "P_REGION3_Y"  VALUES ('Y') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS , 
  SUBPARTITION "P_REGION3_N"  VALUES ('N') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS ) , 
 PARTITION "P_REGION4"  VALUES LESS THAN (5) 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 ( SUBPARTITION "P_REGION4_Y"  VALUES ('Y') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS , 
  SUBPARTITION "P_REGION4_N"  VALUES ('N') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS ) , 
 PARTITION "P_REGION5"  VALUES LESS THAN (6) 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 ( SUBPARTITION "P_REGION5_Y"  VALUES ('Y') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS , 
  SUBPARTITION "P_REGION5_N"  VALUES ('N') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS ) , 
 PARTITION "P_REGION6"  VALUES LESS THAN (7) 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 ( SUBPARTITION "P_REGION6_Y"  VALUES ('Y') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS , 
  SUBPARTITION "P_REGION6_N"  VALUES ('N') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS ) , 
 PARTITION "P_REGION7"  VALUES LESS THAN (8) 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 ( SUBPARTITION "P_REGION7_Y"  VALUES ('Y') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS , 
  SUBPARTITION "P_REGION7_N"  VALUES ('N') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS ) , 
 PARTITION "P_REGION8"  VALUES LESS THAN (9) 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 ( SUBPARTITION "P_REGION8_Y"  VALUES ('Y') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS , 
  SUBPARTITION "P_REGION8_N"  VALUES ('N') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS ) , 
 PARTITION "P_REGION9"  VALUES LESS THAN (10) 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 ( SUBPARTITION "P_REGION9_Y"  VALUES ('Y') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS , 
  SUBPARTITION "P_REGION9_N"  VALUES ('N') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS ) , 
 PARTITION "P_REGION10"  VALUES LESS THAN (11) 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 ( SUBPARTITION "P_REGION10_Y"  VALUES ('Y') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS , 
  SUBPARTITION "P_REGION10_N"  VALUES ('N') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS ) , 
 PARTITION "P_REGION11"  VALUES LESS THAN (12) 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS  NOLOGGING 
 ( SUBPARTITION "P_REGION11_Y"  VALUES ('Y') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS , 
  SUBPARTITION "P_REGION11_N"  VALUES ('N') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS ) , 
 PARTITION "P_REGION12"  VALUES LESS THAN (13) 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS  NOLOGGING 
 ( SUBPARTITION "P_REGION12_Y"  VALUES ('Y') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS , 
  SUBPARTITION "P_REGION12_N"  VALUES ('N') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS ) , 
 PARTITION "P_REGION13"  VALUES LESS THAN (14) 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS  NOLOGGING 
 ( SUBPARTITION "P_REGION13_Y"  VALUES ('Y') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS , 
  SUBPARTITION "P_REGION13_N"  VALUES ('N') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS ) , 
 PARTITION "P_REGION14"  VALUES LESS THAN (15) 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS  NOLOGGING 
 ( SUBPARTITION "P_REGION14_Y"  VALUES ('Y') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS , 
  SUBPARTITION "P_REGION14_N"  VALUES ('N') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS ) , 
 PARTITION "P_REGION15"  VALUES LESS THAN (16) 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS  NOLOGGING 
 ( SUBPARTITION "P_REGION15_Y"  VALUES ('Y') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS , 
  SUBPARTITION "P_REGION15_N"  VALUES ('N') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS ) , 
 PARTITION "P_REGION16"  VALUES LESS THAN (17) 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS  NOLOGGING 
 ( SUBPARTITION "P_REGION16_Y"  VALUES ('Y') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS , 
  SUBPARTITION "P_REGION16_N"  VALUES ('N') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS ) , 
 PARTITION "P_REGION17"  VALUES LESS THAN (18) 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS  NOLOGGING 
 ( SUBPARTITION "P_REGION17_Y"  VALUES ('Y') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS , 
  SUBPARTITION "P_REGION17_N"  VALUES ('N') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS ) , 
 PARTITION "P_REGION18"  VALUES LESS THAN (19) 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS  NOLOGGING 
 ( SUBPARTITION "P_REGION18_Y"  VALUES ('Y') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS , 
  SUBPARTITION "P_REGION18_N"  VALUES ('N') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS ) , 
 PARTITION "P_REGION19"  VALUES LESS THAN (20) 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS  NOLOGGING 
 ( SUBPARTITION "P_REGION19_Y"  VALUES ('Y') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS , 
  SUBPARTITION "P_REGION19_N"  VALUES ('N') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS ) , 
 PARTITION "P_REGION20"  VALUES LESS THAN (21) 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS  NOLOGGING 
 ( SUBPARTITION "P_REGION20_Y"  VALUES ('Y') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS , 
  SUBPARTITION "P_REGION20_N"  VALUES ('N') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS ) )  ENABLE ROW MOVEMENT

CSV文件包含带区域1-10的区域列，

这是分区范围值 “分区范围”

插入语句：

INSERT INTO USER_PARTITION
  (SERIAL_ID, ACCOUNT_GUID, MEMBER_ACCESS_LEVEL, USER_GUID, 
   ACCOUNT_ACCESS_LEVEL, SHARE_ACCOUNT_GUID, CASE_ACCESS_LEVEL, 
   OPPORTUNITY_ACCESS_LEVEL, USER_GROUP_GUID, STATUS, 
   TEAM_MEMBER_ROLE_NAME, COUNTRY_CODE, REGION, ACCOUNT_ID, 
   BADGE_NUMBER, CREATION_DATE, PROCESS_FLAG,
   REC_INSERT_DATE)
VALUES
  (5095611237,'0017000000UWQ2WAAX','Edit','005A0000006zU2qIAE',
   'Edit','0017000000UWP2QAAX','Edit',
   'Edit','005A0000007cU2qIAE','I',
   '3rd Party Software TSR','FJ',1,2224808630,
   '1111441', to_date('29-Apr-22', 'DD-MON-RR'), '',
    to_date('29-Apr-22', 'DD-MON-RR'));

错误： 从行开始：8命令 -

错误报告 - ORA-14400：插入分区密钥不映射到任何分区

原文

I am trying to import data into table from a csv file, the column names are same and datatype matches. While i try to import I am hitting with below error.

enter image description here

DDL :

    CREATE TABLE "HR"."USER_PARTITION" 
       (    "SERIAL_ID" NUMBER, 
        "ACCOUNT_GUID" VARCHAR2(18 CHAR), 
        "MEMBER_ACCESS_LEVEL" VARCHAR2(80 CHAR), 
        "USER_GUID" VARCHAR2(18 CHAR), 
        "ACCOUNT_ACCESS_LEVEL" VARCHAR2(40 CHAR), 
        "SHARE_ACCOUNT_GUID" VARCHAR2(18 CHAR), 
        "CASE_ACCESS_LEVEL" VARCHAR2(40 CHAR), 
        "OPPORTUNITY_ACCESS_LEVEL" VARCHAR2(40 CHAR), 
        "USER_GROUP_GUID" VARCHAR2(18 CHAR), 
        "STATUS" VARCHAR2(20 CHAR), 
        "TEAM_MEMBER_ROLE_NAME" VARCHAR2(180 CHAR), 
        "COUNTRY_CODE" VARCHAR2(60 CHAR), 
        "REGION" NUMBER, 
        "ACCOUNT_ID" NUMBER, 
        "BADGE_NUMBER" VARCHAR2(18 CHAR), 
        "CREATION_DATE" DATE DEFAULT NULL, 
        "PROCESS_FLAG" VARCHAR2(1 BYTE) DEFAULT 'N', 
        "REC_INSERT_DATE" DATE
       ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
      STORAGE(
      BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
      TABLESPACE "SC_DATA01" 
      PARTITION BY RANGE ("REGION") 
      SUBPARTITION BY LIST ("PROCESS_FLAG") 
(PARTITION "P_REGION1"  VALUES LESS THAN (2) 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 ( SUBPARTITION "P_REGION1_Y"  VALUES ('Y') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS , 
  SUBPARTITION "P_REGION1_N"  VALUES ('N') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS ) , 
 PARTITION "P_REGION2"  VALUES LESS THAN (3) 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 ( SUBPARTITION "P_REGION2_Y"  VALUES ('Y') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS , 
  SUBPARTITION "P_REGION2_N"  VALUES ('N') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS ) , 
 PARTITION "P_REGION3"  VALUES LESS THAN (4) 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 ( SUBPARTITION "P_REGION3_Y"  VALUES ('Y') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS , 
  SUBPARTITION "P_REGION3_N"  VALUES ('N') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS ) , 
 PARTITION "P_REGION4"  VALUES LESS THAN (5) 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 ( SUBPARTITION "P_REGION4_Y"  VALUES ('Y') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS , 
  SUBPARTITION "P_REGION4_N"  VALUES ('N') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS ) , 
 PARTITION "P_REGION5"  VALUES LESS THAN (6) 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 ( SUBPARTITION "P_REGION5_Y"  VALUES ('Y') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS , 
  SUBPARTITION "P_REGION5_N"  VALUES ('N') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS ) , 
 PARTITION "P_REGION6"  VALUES LESS THAN (7) 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 ( SUBPARTITION "P_REGION6_Y"  VALUES ('Y') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS , 
  SUBPARTITION "P_REGION6_N"  VALUES ('N') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS ) , 
 PARTITION "P_REGION7"  VALUES LESS THAN (8) 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 ( SUBPARTITION "P_REGION7_Y"  VALUES ('Y') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS , 
  SUBPARTITION "P_REGION7_N"  VALUES ('N') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS ) , 
 PARTITION "P_REGION8"  VALUES LESS THAN (9) 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 ( SUBPARTITION "P_REGION8_Y"  VALUES ('Y') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS , 
  SUBPARTITION "P_REGION8_N"  VALUES ('N') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS ) , 
 PARTITION "P_REGION9"  VALUES LESS THAN (10) 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 ( SUBPARTITION "P_REGION9_Y"  VALUES ('Y') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS , 
  SUBPARTITION "P_REGION9_N"  VALUES ('N') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS ) , 
 PARTITION "P_REGION10"  VALUES LESS THAN (11) 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 ( SUBPARTITION "P_REGION10_Y"  VALUES ('Y') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS , 
  SUBPARTITION "P_REGION10_N"  VALUES ('N') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS ) , 
 PARTITION "P_REGION11"  VALUES LESS THAN (12) 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS  NOLOGGING 
 ( SUBPARTITION "P_REGION11_Y"  VALUES ('Y') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS , 
  SUBPARTITION "P_REGION11_N"  VALUES ('N') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS ) , 
 PARTITION "P_REGION12"  VALUES LESS THAN (13) 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS  NOLOGGING 
 ( SUBPARTITION "P_REGION12_Y"  VALUES ('Y') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS , 
  SUBPARTITION "P_REGION12_N"  VALUES ('N') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS ) , 
 PARTITION "P_REGION13"  VALUES LESS THAN (14) 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS  NOLOGGING 
 ( SUBPARTITION "P_REGION13_Y"  VALUES ('Y') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS , 
  SUBPARTITION "P_REGION13_N"  VALUES ('N') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS ) , 
 PARTITION "P_REGION14"  VALUES LESS THAN (15) 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS  NOLOGGING 
 ( SUBPARTITION "P_REGION14_Y"  VALUES ('Y') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS , 
  SUBPARTITION "P_REGION14_N"  VALUES ('N') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS ) , 
 PARTITION "P_REGION15"  VALUES LESS THAN (16) 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS  NOLOGGING 
 ( SUBPARTITION "P_REGION15_Y"  VALUES ('Y') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS , 
  SUBPARTITION "P_REGION15_N"  VALUES ('N') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS ) , 
 PARTITION "P_REGION16"  VALUES LESS THAN (17) 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS  NOLOGGING 
 ( SUBPARTITION "P_REGION16_Y"  VALUES ('Y') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS , 
  SUBPARTITION "P_REGION16_N"  VALUES ('N') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS ) , 
 PARTITION "P_REGION17"  VALUES LESS THAN (18) 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS  NOLOGGING 
 ( SUBPARTITION "P_REGION17_Y"  VALUES ('Y') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS , 
  SUBPARTITION "P_REGION17_N"  VALUES ('N') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS ) , 
 PARTITION "P_REGION18"  VALUES LESS THAN (19) 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS  NOLOGGING 
 ( SUBPARTITION "P_REGION18_Y"  VALUES ('Y') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS , 
  SUBPARTITION "P_REGION18_N"  VALUES ('N') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS ) , 
 PARTITION "P_REGION19"  VALUES LESS THAN (20) 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS  NOLOGGING 
 ( SUBPARTITION "P_REGION19_Y"  VALUES ('Y') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS , 
  SUBPARTITION "P_REGION19_N"  VALUES ('N') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS ) , 
 PARTITION "P_REGION20"  VALUES LESS THAN (21) 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS  NOLOGGING 
 ( SUBPARTITION "P_REGION20_Y"  VALUES ('Y') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS , 
  SUBPARTITION "P_REGION20_N"  VALUES ('N') SEGMENT CREATION IMMEDIATE 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SC_DATA01" 
 NOCOMPRESS ) )  ENABLE ROW MOVEMENT

CSV file contains region column with regions 1-10

Here is the partition range values
PARTITION RANGE

INSERT STATEMENT:

INSERT INTO USER_PARTITION
  (SERIAL_ID, ACCOUNT_GUID, MEMBER_ACCESS_LEVEL, USER_GUID, 
   ACCOUNT_ACCESS_LEVEL, SHARE_ACCOUNT_GUID, CASE_ACCESS_LEVEL, 
   OPPORTUNITY_ACCESS_LEVEL, USER_GROUP_GUID, STATUS, 
   TEAM_MEMBER_ROLE_NAME, COUNTRY_CODE, REGION, ACCOUNT_ID, 
   BADGE_NUMBER, CREATION_DATE, PROCESS_FLAG,
   REC_INSERT_DATE)
VALUES
  (5095611237,'0017000000UWQ2WAAX','Edit','005A0000006zU2qIAE',
   'Edit','0017000000UWP2QAAX','Edit',
   'Edit','005A0000007cU2qIAE','I',
   '3rd Party Software TSR','FJ',1,2224808630,
   '1111441', to_date('29-Apr-22', 'DD-MON-RR'), '',
    to_date('29-Apr-22', 'DD-MON-RR'));

ERROR:
Error starting at line : 8 in command -

Error report -
ORA-14400: inserted partition key does not map to any partition

如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论， 你可以免费 注册 一个本站的账号。

评论（2）

烂人 2025-02-19 03:18:22

并非您拥有的所有新元素都与您的分区之一相匹配。通过创建一个或多个分区来解决这个问题，例如

alter table "HR"."USER_PARTITION" add partition <some name> values less than <the highest REGION in your csv + 1>;

Not all the new elements you have are matching one of your partitions. To solve this issue by the creation of one or more further partitions, like

alter table "HR"."USER_PARTITION" add partition <some name> values less than <the highest REGION in your csv + 1>;
回复 原文
小傻瓜 2025-02-19 03:18:22

您的表按区域划分，由process_flag子分区。有针对区域= 1至20的分区，在（'y'，'n'）中的每个区域中的每个区域中的分区。如果您的电子表格中的区域中有任何值，该值不在1..20的范围内，或者不是'y'或'n'的process_flag值，那么您将获得所遇到的错误。您必须检查数据并标识没有有效值列表中的值的行，然后修复数据或将分区添加到表中。

Your table is partitioned by REGION, subpartitioned by PROCESS_FLAG. There are partitions for REGION = 1 through 20, and subpartitions in each region for PROCESS_FLAG in ('Y', 'N'). If you have any values in your spreadsheet for REGION which are not in the range of 1..20, or values for PROCESS_FLAG which are not 'Y' or 'N' then you'll get the error you're getting. You'll have to check your data and identify the row(s) which have values which are not in the list of valid values above, and then either fix the data or add partitions to your table.

回复 原文
~没有更多了~

关于作者

蘸点软妹酱

暂无简介

文章
评论
26 人气
发私信

相关话题

更多

热门标签

操作系统 程序设计 IT运维 Linux系统管理 JavaScript 服务器应用 solaris C/C++ PHP Shell BSD Vue.js aix Oracle Python HTML 系统管理 HTML5 CSS 前端
更多

推荐作者

alipaysp_snBf0MSZIv

文章 0 评论 0

梦断已成空

文章 0 评论 0

瞎闹

文章 0 评论 0

凯凯我们等你回来

文章 0 评论 0

寄意

文章 0 评论 0

似梦非梦

文章 0 评论 0

更多

友情链接

文江博客
    我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站，即表示您同意使用 Cookies 和您的相关数据。
    原文