??????????????????

????????????????????????
???????????????????oracle_datapump?????????????????
create table test.charge_ext_20150609
ORGANIZATION EXTERNAL
(TYPE ORACLE_DATAPUMP
DEFAULT DIRECTORY xxxxx
LOCATION (
‘charge_201506609.dmp’……….
)
)
parallel 4    as
select /*+ parallel(t 4) */ * from charge partition(P_20150609) t;
drop test.mo1_memo_ext; --????dump??????????????
??????????
??????????????????????????????????????
Create table charge_ext_20150609
(    id number??object_id number??object_name varchar2(30)??object_type varchar2(30)??clob_test clob xxxx??charge_date date
)
ORGANIZATION EXTERNAL
( TYPE ORACLE_DATAPUMP
DEFAULT DIRECTORY "EXPDP_LOCATION"
LOCATION(
‘charge_20150609.dmp’
)
)
PARALLEL 2;
????С????????
????create table charge_tmp_20150609 as select *from charge_ext_20150609 where  charge_date between xxx_8pm to xxx_9pm;
?????????????????????????????????insert append????
????Insert /*+append */ into xxx.charge select *from charge_ext_20150609;
????Commit;