zl程序教程

您现在的位置是:首页 >  大数据

当前栏目

数据泵

2023-09-14 08:59:31 时间

获取数据库使用方法

su - oracle
--执行此命令,获取帮助信息;

/$ORACLE_HOME/bin/expdp -help
View Code
expdp TEST/TEST dumpfile=test.dmp directory=dmp_dir tables=t logfile=test.log 

expdp TEST/TEST DUMPFILE=test.dmp DIRECTORY=dmp_dir tables=t logfile=test.log
导出数据命令

--导入数据表

impdp TEST/TEST DUMPFILE=TEST.DMP DIRECTORY=dmp_dir logfile=test.log
View Code

--导入数据表,但是排除索引导入

impdp TEST/TEST DUMPFILE=TEST.DMP DIRECTORY=dmp_dir logfile=test.log exclude=index
View Code

/*------------------------------------------------------------------------------案例----------------------------------------------------------------------------/

  单张表的导出与导入

  被导出表:HNDATA.MFF_DPI_READING_FLOW

  被导出表所在表空间:HNDATA_DPI_TBSPC

 

  导入表:ARCERZHANG.MFF_DPI_READING_FLOW

  导入表所在表空间:PERFORM_TUNING_TBSPC

/* -----------------------------------------------------------------------------案例---------------------------------------------------------------------------/

 

执行导出操作

[oracle@test ~]$ expdp hndata/1 directory=exp_dir dumpfile=MFF_DPI_READING_FLOW.dmp tables=MFF_DPI_READING_FLOW

Export: Release 11.2.0.3.0 - Production on Fri Jul 25 11:47:17 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "HNDATA"."SYS_EXPORT_TABLE_01":  hndata/******** directory=exp_dir dumpfile=MFF_DPI_READING_FLOW.dmp tables=MFF_DPI_READING_FLOW 
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 392 MB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201403310000"  329.7 MB  688808 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201403250000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201403260000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201403280000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201403290000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201403300000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201404010000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201404020000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201404030000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201404040000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201404050000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201404060000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201404070000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201404080000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201404090000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201404100000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201404110000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201404120000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201404130000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201404140000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201404150000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201404160000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201404170000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201404180000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201404190000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201404200000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201404210000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201404220000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201404230000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201404240000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201404250000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201404260000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201404270000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201404280000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201404290000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201404300000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201405010000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201405020000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201405030000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201405040000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201405050000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201405060000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201405070000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201405080000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201405090000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201405100000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201405110000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201405120000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201405130000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201405140000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201405150000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201405160000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201405170000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201405180000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201405190000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201405200000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201405210000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201405220000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201405230000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201405240000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201405250000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201405260000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201405270000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201405280000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201405290000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201405300000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201405310000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201406010000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201406020000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201406030000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201406040000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201406050000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201406060000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201406070000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201406080000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201406090000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201406100000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201406110000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201406120000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201406130000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201406140000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201406150000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201406160000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201406170000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201406180000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201406190000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201406200000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201406210000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201406220000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201406230000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201406240000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201406250000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201406260000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201406270000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201406280000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201406290000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201406300000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201407010000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201407020000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201407030000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201407040000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201407050000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201407060000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201407070000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201407080000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201407090000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201407100000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201407110000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201407120000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201407130000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201407140000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201407150000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201407160000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201407170000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201407180000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201407190000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201407200000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201407210000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201407220000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201407230000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201407240000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201407250000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201407260000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201407270000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201407280000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201407290000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201407300000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201407310000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201408010000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201408020000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201408030000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201408040000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201408050000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201408060000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201408070000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201408080000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201408090000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201408100000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201408110000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201408120000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201408130000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201408140000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201408150000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201408160000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201408170000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201408180000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201408190000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201408200000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201408210000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201408220000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201408230000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201408240000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201408250000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201408260000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201408270000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201408280000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201408290000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201408300000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201408310000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201409010000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201409020000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201409030000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201409040000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201409050000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201409060000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201409070000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201409080000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201409090000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201409100000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201409110000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201409120000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201409130000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201409140000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201409150000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201409160000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201409170000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201409180000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201409190000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201409200000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201409210000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201409220000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201409230000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201409240000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201409250000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201409260000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201409270000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201409280000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201409290000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201409300000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201410010000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201410020000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201410030000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201410040000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201410050000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201410060000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201410070000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201410080000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201410090000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201410100000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201410110000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201410120000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201410130000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201410140000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201410150000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201410160000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201410170000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201410180000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201410190000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201410200000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201410210000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201410220000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201410230000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201410240000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201410250000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201410260000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201410270000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201410280000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201410290000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201410300000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201410310000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201411010000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201411020000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201411030000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201411040000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201411050000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201411060000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201411070000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201411080000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201411090000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201411100000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201411110000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201411120000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201411130000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201411140000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201411150000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201411160000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201411170000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201411180000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201411190000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201411200000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201411210000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201411220000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201411230000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201411240000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201411250000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201411260000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201411270000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201411280000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201411290000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201411300000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201412010000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201412020000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201412030000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201412040000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201412050000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201412060000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201412070000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201412080000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201412090000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201412100000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201412110000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201412120000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201412130000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201412140000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201412150000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201412160000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201412170000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201412180000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201412190000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201412200000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201412210000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201412220000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201412230000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201412240000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201412250000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201412260000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201412270000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201412280000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201412290000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201412300000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201412310000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201501010000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201501020000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201501030000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201501040000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201501050000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201501060000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201501070000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201501080000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201501090000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201501100000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201501110000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201501120000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201501130000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201501140000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201501150000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201501160000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201501170000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201501180000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201501190000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201501200000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201501210000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201501220000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201501230000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201501240000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201501250000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201501260000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201501270000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201501280000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201501290000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201501300000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201501310000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201502010000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201502020000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201502030000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201502040000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201502050000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201502060000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201502070000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201502080000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201502090000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201502100000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201502110000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201502120000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201502130000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201502140000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201502150000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201502160000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201502170000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201502180000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201502190000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201502200000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201502210000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201502220000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201502230000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201502240000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201502250000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201502260000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201502270000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201502280000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201503010000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201503020000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201503030000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201503040000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201503050000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201503060000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201503070000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201503080000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201503090000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201503100000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201503110000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201503120000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201503130000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201503140000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201503150000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201503160000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201503170000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201503180000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201503190000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201503200000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201503210000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201503220000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201503230000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201503240000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201503250000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201503260000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201503270000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201503280000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201503290000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201503300000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201503310000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201504010000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201504020000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201504030000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201504040000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201504050000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201504060000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201504070000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201504080000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201504090000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201504100000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201504110000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201504120000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201504130000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201504140000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201504150000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201504160000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201504170000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201504180000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201504190000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201504200000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201504210000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201504220000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201504230000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201504240000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201504250000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201504260000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201504270000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201504280000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201504290000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201504300000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201505010000"      0 KB       0 rows
. . exported "HNDATA"."MFF_DPI_READING_FLOW":"P_201505020000"      0 KB       0 rows
Master table "HNDATA"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for HNDATA.SYS_EXPORT_TABLE_01 is:
  /home/app/oracle/exp_dir/MFF_DPI_READING_FLOW.dmp
Job "HNDATA"."SYS_EXPORT_TABLE_01" successfully completed at 11:47:31
View Code

 执行导入操作

[oracle@test ~]$ impdp arcerzhang/arcerzhang directory=exp_dir dumpfile=MFF_DPI_READING_FLOW.dmp tables=HNDATA.MFF_DPI_READING_FLOW remap_schema=HNDATA:ARCERZHANG remap_tablespace=HNDATA_DPI_TBSPC:PERFORM_TUNING_TBSPC

Import: Release 11.2.0.3.0 - Production on Fri Jul 25 11:58:03 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "ARCERZHANG"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded
Starting "ARCERZHANG"."SYS_IMPORT_TABLE_01":  arcerzhang/******** directory=exp_dir dumpfile=MFF_DPI_READING_FLOW.dmp tables=HNDATA.MFF_DPI_READING_FLOW remap_schema=HNDATA:ARCERZHANG remap_tablespace=HNDATA_DPI_TBSPC:PERFORM_TUNING_TBSPC 
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201403310000"  329.7 MB  688808 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201403250000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201403260000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201403280000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201403290000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201403300000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201404010000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201404020000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201404030000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201404040000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201404050000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201404060000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201404070000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201404080000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201404090000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201404100000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201404110000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201404120000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201404130000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201404140000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201404150000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201404160000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201404170000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201404180000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201404190000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201404200000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201404210000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201404220000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201404230000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201404240000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201404250000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201404260000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201404270000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201404280000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201404290000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201404300000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201405010000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201405020000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201405030000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201405040000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201405050000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201405060000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201405070000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201405080000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201405090000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201405100000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201405110000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201405120000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201405130000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201405140000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201405150000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201405160000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201405170000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201405180000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201405190000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201405200000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201405210000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201405220000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201405230000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201405240000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201405250000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201405260000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201405270000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201405280000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201405290000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201405300000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201405310000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201406010000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201406020000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201406030000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201406040000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201406050000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201406060000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201406070000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201406080000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201406090000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201406100000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201406110000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201406120000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201406130000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201406140000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201406150000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201406160000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201406170000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201406180000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201406190000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201406200000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201406210000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201406220000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201406230000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201406240000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201406250000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201406260000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201406270000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201406280000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201406290000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201406300000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201407010000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201407020000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201407030000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201407040000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201407050000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201407060000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201407070000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201407080000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201407090000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201407100000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201407110000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201407120000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201407130000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201407140000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201407150000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201407160000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201407170000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201407180000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201407190000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201407200000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201407210000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201407220000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201407230000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201407240000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201407250000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201407260000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201407270000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201407280000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201407290000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201407300000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201407310000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201408010000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201408020000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201408030000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201408040000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201408050000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201408060000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201408070000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201408080000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201408090000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201408100000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201408110000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201408120000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201408130000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201408140000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201408150000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201408160000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201408170000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201408180000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201408190000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201408200000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201408210000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201408220000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201408230000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201408240000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201408250000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201408260000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201408270000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201408280000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201408290000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201408300000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201408310000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201409010000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201409020000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201409030000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201409040000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201409050000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201409060000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201409070000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201409080000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201409090000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201409100000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201409110000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201409120000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201409130000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201409140000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201409150000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201409160000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201409170000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201409180000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201409190000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201409200000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201409210000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201409220000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201409230000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201409240000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201409250000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201409260000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201409270000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201409280000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201409290000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201409300000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201410010000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201410020000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201410030000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201410040000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201410050000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201410060000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201410070000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201410080000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201410090000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201410100000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201410110000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201410120000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201410130000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201410140000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201410150000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201410160000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201410170000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201410180000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201410190000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201410200000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201410210000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201410220000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201410230000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201410240000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201410250000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201410260000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201410270000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201410280000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201410290000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201410300000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201410310000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201411010000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201411020000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201411030000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201411040000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201411050000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201411060000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201411070000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201411080000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201411090000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201411100000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201411110000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201411120000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201411130000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201411140000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201411150000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201411160000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201411170000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201411180000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201411190000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201411200000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201411210000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201411220000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201411230000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201411240000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201411250000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201411260000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201411270000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201411280000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201411290000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201411300000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201412010000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201412020000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201412030000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201412040000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201412050000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201412060000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201412070000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201412080000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201412090000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201412100000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201412110000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201412120000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201412130000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201412140000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201412150000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201412160000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201412170000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201412180000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201412190000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201412200000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201412210000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201412220000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201412230000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201412240000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201412250000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201412260000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201412270000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201412280000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201412290000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201412300000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201412310000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201501010000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201501020000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201501030000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201501040000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201501050000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201501060000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201501070000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201501080000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201501090000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201501100000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201501110000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201501120000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201501130000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201501140000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201501150000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201501160000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201501170000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201501180000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201501190000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201501200000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201501210000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201501220000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201501230000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201501240000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201501250000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201501260000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201501270000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201501280000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201501290000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201501300000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201501310000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201502010000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201502020000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201502030000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201502040000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201502050000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201502060000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201502070000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201502080000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201502090000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201502100000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201502110000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201502120000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201502130000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201502140000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201502150000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201502160000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201502170000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201502180000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201502190000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201502200000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201502210000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201502220000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201502230000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201502240000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201502250000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201502260000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201502270000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201502280000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201503010000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201503020000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201503030000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201503040000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201503050000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201503060000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201503070000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201503080000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201503090000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201503100000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201503110000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201503120000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201503130000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201503140000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201503150000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201503160000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201503170000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201503180000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201503190000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201503200000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201503210000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201503220000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201503230000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201503240000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201503250000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201503260000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201503270000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201503280000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201503290000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201503300000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201503310000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201504010000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201504020000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201504030000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201504040000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201504050000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201504060000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201504070000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201504080000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201504090000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201504100000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201504110000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201504120000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201504130000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201504140000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201504150000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201504160000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201504170000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201504180000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201504190000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201504200000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201504210000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201504220000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201504230000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201504240000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201504250000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201504260000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201504270000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201504280000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201504290000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201504300000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201505010000"      0 KB       0 rows
. . imported "ARCERZHANG"."MFF_DPI_READING_FLOW":"P_201505020000"      0 KB       0 rows
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job "ARCERZHANG"."SYS_IMPORT_TABLE_01" successfully completed at 11:58:27
View Code

验证导入数据

[oracle@test ~]$ sqlplus arcerzhang/arcerzhang

SQL*Plus: Release 11.2.0.3.0 Production on Fri Jul 25 11:58:34 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> col SEGMENT_NAME for a30    
SQL> r
  1  select segment_name,segment_type,tablespace_name from user_segments
  2*

SEGMENT_NAME                   SEGMENT_TYPE       TABLESPACE_NAME
------------------------------ ------------------ ------------------------------
T1                             TABLE PARTITION    PERFORM_TUNING_TBSPC
T1                             TABLE PARTITION    PERFORM_TUNING_TBSPC
T1                             TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC

SEGMENT_NAME                   SEGMENT_TYPE       TABLESPACE_NAME
------------------------------ ------------------ ------------------------------
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC

SEGMENT_NAME                   SEGMENT_TYPE       TABLESPACE_NAME
------------------------------ ------------------ ------------------------------
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC

SEGMENT_NAME                   SEGMENT_TYPE       TABLESPACE_NAME
------------------------------ ------------------ ------------------------------
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC

SEGMENT_NAME                   SEGMENT_TYPE       TABLESPACE_NAME
------------------------------ ------------------ ------------------------------
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC

SEGMENT_NAME                   SEGMENT_TYPE       TABLESPACE_NAME
------------------------------ ------------------ ------------------------------
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC
MFF_DPI_READING_FLOW           TABLE PARTITION    PERFORM_TUNING_TBSPC

64 rows selected.
View Code

 

expdp/impdp参数详解 

oracle数据泵详解