系统环境：
[root@scf108 ~]# uname -a
Linux scf108 2.6.32-431.el6.x86_64 #1 SMP Sun Nov 10 22:19:54 EST 2013 x86_64 x86_64 x86_64 GNU/Linux
[root@scf108 ~]# su - oracle
[oracle@scf108 ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on Tue May 10 10:15:32 2016
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
TWLXQZKQDXQYGTEMP转换前为普通表，导出的数据也是从普通表导出的
执行的操作顺序：
SQL>
1、expdp SYSTEM/oracle TABLES=TWLXQZKQDXQYGTEMP dumpfile=expdp.dmp DIRECTORY=DIR_DP1
2、alter table TWLXQZKQDXQYGTEMP rename to TWLXQZKQDXQYGTEMP_01
3、
create table TWLXQZKQDXQYGTEMP
(
MRPJHQDXLH NUMBER not null,
CGZXLH NUMBER,
CGZBM VARCHAR2(8),
XQDWXLH NUMBER,
XQDWBM VARCHAR2(8),
XQDWDHD VARCHAR2(8),
YHDWDHD VARCHAR2(8),
WLBM VARCHAR2(20) not null,
XQDWWLFL VARCHAR2(6),
YHDWWLFL VARCHAR2(6),
WLBB VARCHAR2(8),
WLTSYT VARCHAR2(4),
WLXSQY VARCHAR2(4),
WLYS VARCHAR2(6),
ZDGYS VARCHAR2(64),
GYSGS NUMBER,
NY VARCHAR2(6),
ZD VARCHAR2(2),
XQRQ DATE not null,
YHXQRQ DATE,
SXSK VARCHAR2(5),
PLX VARCHAR2(2),
XTSL NUMBER not null,
TZSL NUMBER not null,
TZHSL NUMBER not null,
GHFS VARCHAR2(4) not null,
XQDWZSLX VARCHAR2(8),
YHDWJHY VARCHAR2(8),
ZZLX VARCHAR2(4),
ZPLX VARCHAR2(4),
LASTMODIFIEDTIME DATE,
CREATETIME DATE,
ISDELETE VARCHAR2(1),
UPDATOR VARCHAR2(8),
JHLB VARCHAR2(4),
CGZZBM VARCHAR2(8),
CGZZXLH NUMBER,
XXLY NUMBER,
SCXBM VARCHAR2(3),
SXRQ DATE,
ZPSL NUMBER,
ZCSL NUMBER,
DDH VARCHAR2(32)
)
partition by range(NY)
(
PARTITION part01 VALUES LESS THAN ('201509') TABLESPACE BAS_DATA_02,
PARTITION part02 VALUES LESS THAN ('201510') TABLESPACE BAS_DATA_02,
PARTITION part03 VALUES LESS THAN ('201511') TABLESPACE BAS_DATA_02,
PARTITION part04 VALUES LESS THAN ('201512') TABLESPACE BAS_DATA_02,
PARTITION part05 VALUES LESS THAN ('201601') TABLESPACE BAS_DATA_02,
PARTITION part06 VALUES LESS THAN ('201602') TABLESPACE BAS_DATA_02,
PARTITION part07 VALUES LESS THAN ('201603') TABLESPACE BAS_DATA_02,
PARTITION part08 VALUES LESS THAN ('201604') TABLESPACE BAS_DATA_02,
PARTITION part09 VALUES LESS THAN ('201605') TABLESPACE BAS_DATA_02
)
tablespace BAS_DATA_02
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
4、
[oracle@scf108 ~]$ impdp SYSTEM/oracle TABLES=SCF2.TWLXQZKQDXQYGTEMP dumpfile=expdp.dmp DIRECTORY=DIR_DP1 TABLE_EXISTS_ACTION=APPEND;
Import: Release 10.2.0.5.0 - 64bit Production on Tuesday, 10 May, 2016 9:59:32
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYSTEM"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_TABLE_01": SYSTEM/******** TABLES=SCF2.TWLXQZKQDXQYGTEMP dumpfile=expdp.dmp DIRECTORY=DIR_DP1 TABLE_EXISTS_ACTION=APPEND
Processing object type TABLE_EXPORT/TABLE/TABLE
ORA-39152: Table "SCF2"."TWLXQZKQDXQYGTEMP" exists. Data will be appended to existing table but all dependent metadata will be skipped due to table_exists_action of append
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "SCF2"."TWLXQZKQDXQYGTEMP" 1.135 GB 7363883 rows
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job "SYSTEM"."SYS_IMPORT_TABLE_01" completed with 1 error(s) at 09:59:45
5、
SQL> select CGZBM， WLTSYT，NY
from TWLXQZKQDXQYGTEMP partition(part01) ;
no rows selected
6、
> select CGZBM， WLTSYT，NY from TWLXQZKQDXQYGTEMP partition(part02) ;
CGZBM WLTSYT NY
------------------------ ------------ ------------------
8000CGZ 0303 201509
8000CGZ 0303 201509
8000CGZ 0303 201509
8000CGZ 0303 201509
8000CGZ 0303 201509
8000CGZ 0303 201509
8000CGZ 0303 201509
8000CGZ 0303 201509
8000CGZ 0303 201509
8000CGZ 0303 201509
8000CGZ 0303 201509
执行结果就是9月份的数据存储到10月份的分区字段中
问题
导入分区表的数据为什么没有按分区字段进行存储数据