一:创建分区表create table T_PM_ACCT_DTL_AF_TEST(  DATA_DATE      NUMBER(8),  ACCT_NO        VARCHAR2(100),  ACCT_ORD       VARCHAR2(30),  ACCT_NO_PK     VARCHAR2(100),  ACCT_BAL       NUMBER(18,4),  D_CMP_BAL      NUMBER(24,4),  M_CMP_BAL      NUMBER(24,4),  Y_CMP_BAL      NUMBER(24,4),  FLAG           VARCHAR2(10),  ACCT_FLAG      VARCHAR2(10),  TERM           NUMBER(8),  TERM_FLAG      VARCHAR2(10),  CUR_CODE       VARCHAR2(8),  CUR_NAME       VARCHAR2(20),  SUB_CODE       VARCHAR2(50),  CUST_NO        VARCHAR2(30),  CUST_TYPE      VARCHAR2(10),  CUST_NAME      VARCHAR2(60),  BANK_CORP_CODE VARCHAR2(10),  BRAN_NAME      VARCHAR2(50),  MGR_CODE       VARCHAR2(30),  MGR_NAME       VARCHAR2(50),  OPEN_DATE      VARCHAR2(10),  FIX_BAL        NUMBER(16,2),  DIV_FIX_FLAG   NUMBER(1),  ADJUST_AMT     NUMBER(16,2),  ADJUST_AMT_AF  NUMBER(24,4),  Y_AVG_AF       NUMBER(24,4),  Y_ADD_AF       NUMBER(24,4),  ACCT_INTR      NUMBER(16,2),  SIM_PROFIT     NUMBER(16,2),  SEPA_POR       NUMBER(6,2),  PRI            NUMBER(5),  BRAN_CODE      VARCHAR2(50),  UNIT1_CODE     VARCHAR2(10),  UNIT2_CODE     VARCHAR2(10),  UNIT3_CODE     VARCHAR2(10),  DEPT1_CODE     VARCHAR2(10),  INTR_RATE      NUMBER(11,6),  DUE_DATE       NUMBER(8))partition by list (DATA_DATE)(  partition ACCT_DTL_AF_20090101 values (20090101)    tablespace CZCB_DATA01    pctfree 10    initrans 1    maxtrans 255    storage    (      initial 256K      next 256K      minextents 1      maxextents unlimited    ))；二：添加分区alter table T_PM_ACCT_DTL_AF_test add partition ACCT_DTL_AF_20090102 values(20090102) tablespace CZCB_DATA01三:访问分区    select * from T_PM_ACCT_DTL_AF_test partition(ACCT_DTL_AF_20090101)四：定义分区界限SQL>    insert into T_PM_ACCT_DTL_AF_test(DATA_DATE) values(20120101);   insert into T_PM_ACCT_DTL_AF_test(DATA_DATE) values(20120101)               *ERROR at line 1:ORA-14400: inserted partition key does not map to any partition；添加分区界限:alter table T_PM_ACCT_DTL_AF_test add partition ACCT_DTL_AF_MAX  values(DEFAULT) tablespace CZCB_DATA01