现有两张表,一张分区表,一张表。语法如下:
未分区表:
CREATE TABLE MDBADMIN.ACT_LOG
(
ID NUMBER NOT NULL,
PERSID NVARCHAR2(30),
CALL_REQ_ID NVARCHAR2(30),
LAST_MOD_DT NUMBER,
TIME_SPENT NUMBER,
TIME_STAMP NUMBER,
SYSTEM_TIME NUMBER,
ANALYST RAW(16),
DESCRIPTION NCLOB,
ACTION_DESC NCLOB,
TYPE NVARCHAR2(30),
KNOWLEDGE_SESSION NVARCHAR2(80),
KNOWLEDGE_TOOL NVARCHAR2(12),
INTERNAL NUMBER
)
TABLESPACE MDB_DATA
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING
;
分区表:
CREATE TABLE MDBADMIN.ACT_LOG1
(
ID NUMBER NOT NULL,
PERSID NVARCHAR2(30),
CALL_REQ_ID NVARCHAR2(30),
LAST_MOD_DT NUMBER,
TIME_SPENT NUMBER,
TIME_STAMP NUMBER,
SYSTEM_TIME NUMBER,
ANALYST RAW(16),
DESCRIPTION NCLOB,
ACTION_DESC NCLOB,
TYPE NVARCHAR2(30),
KNOWLEDGE_SESSION NVARCHAR2(80),
KNOWLEDGE_TOOL NVARCHAR2(12),
INTERNAL NUMBER
)
TABLESPACE MDB_DATA
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING
partition by range (ID)
(
partition part_01 values less than(1000000) tablespace dinya_space01,
partition part_02 values less than(2000000) tablespace dinya_space02,
partition part_03 values less than(maxvalue) tablespace dinya_space03
);
然后使用
insert into act_log1 ( select * from MDBADMIN.ACT_LOG);
用了很长时间。结果也没导入到分区表中。
如何使用impdp把一张现有表导入到分区表当中?