包含统计信息导出：
[oracle@hadoop01 dumpfile]$ expdp system/oracle directory=dmpdir dumpfile=shplus.dmp logfile=shplus.log schemas=sh
Export: Release 11.2.0.3.0 - Production on Tue Jul 26 11:53:33 2016
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, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/******** directory=dmpdir dumpfile=shplus.dmp logfile=shplus.log schemas=sh
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 273.8 MB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/BITMAP_INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/BITMAP_INDEX/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/INDEX/DOMAIN_INDEX/INDEX
Processing object type SCHEMA_EXPORT/MATERIALIZED_VIEW
Processing object type SCHEMA_EXPORT/DIMENSION
. . exported "SH"."CUSTOMERS" 9.853 MB 55500 rows
. . exported "SH"."COSTS":"COSTS_Q1_1998" 139.5 KB 4411 rows
. . exported "SH"."COSTS":"COSTS_Q1_1999" 183.5 KB 5884 rows
. . exported "SH"."COSTS":"COSTS_Q1_2000" 120.6 KB 3772 rows
. . exported "SH"."COSTS":"COSTS_Q1_2001" 227.8 KB 7328 rows
. . exported "SH"."COSTS":"COSTS_Q2_1998" 79.52 KB 2397 rows
. . exported "SH"."COSTS":"COSTS_Q2_1999" 132.5 KB 4179 rows
. . exported "SH"."COSTS":"COSTS_Q2_2000" 119.0 KB 3715 rows
. . exported "SH"."COSTS":"COSTS_Q2_2001" 184.5 KB 5882 rows
. . exported "SH"."COSTS":"COSTS_Q3_1998" 131.1 KB 4129 rows
. . exported "SH"."COSTS":"COSTS_Q3_1999" 137.3 KB 4336 rows
. . exported "SH"."COSTS":"COSTS_Q3_2000" 151.4 KB 4798 rows
. . exported "SH"."COSTS":"COSTS_Q3_2001" 234.4 KB 7545 rows
. . exported "SH"."COSTS":"COSTS_Q4_1998" 144.7 KB 4577 rows
. . exported "SH"."COSTS":"COSTS_Q4_1999" 159.0 KB 5060 rows
. . exported "SH"."COSTS":"COSTS_Q4_2000" 160.2 KB 5088 rows
. . exported "SH"."COSTS":"COSTS_Q4_2001" 278.4 KB 9011 rows
. . exported "SH"."SALES":"SALES_Q1_1998" 1.412 MB 43687 rows
. . exported "SH"."SALES":"SALES_Q1_1999" 2.071 MB 64186 rows
. . exported "SH"."SALES":"SALES_Q1_2000" 2.012 MB 62197 rows
. . exported "SH"."SALES":"SALES_Q1_2001" 1.965 MB 60608 rows
. . exported "SH"."SALES":"SALES_Q2_1998" 1.160 MB 35758 rows
. . exported "SH"."SALES":"SALES_Q2_1999" 1.754 MB 54233 rows
. . exported "SH"."SALES":"SALES_Q2_2000" 1.802 MB 55515 rows
. . exported "SH"."SALES":"SALES_Q2_2001" 2.051 MB 63292 rows
. . exported "SH"."SALES":"SALES_Q3_1998" 1.633 MB 50515 rows
. . exported "SH"."SALES":"SALES_Q3_1999" 2.166 MB 67138 rows
. . exported "SH"."SALES":"SALES_Q3_2000" 1.909 MB 58950 rows
. . exported "SH"."SALES":"SALES_Q3_2001" 2.130 MB 65769 rows
. . exported "SH"."SALES":"SALES_Q4_1998" 1.581 MB 48874 rows
. . exported "SH"."SALES":"SALES_Q4_1999" 2.014 MB 62388 rows
. . exported "SH"."SALES":"SALES_Q4_2000" 1.814 MB 55984 rows
. . exported "SH"."SALES":"SALES_Q4_2001" 2.257 MB 69749 rows
. . exported "SH"."SUPPLEMENTARY_DEMOGRAPHICS" 697.3 KB 4500 rows
. . exported "SH"."FWEEK_PSCAT_SALES_MV" 419.8 KB 11266 rows
. . exported "SH"."PROMOTIONS" 58.89 KB 503 rows
. . exported "SH"."TIMES" 380.8 KB 1826 rows
. . exported "SH"."CAL_MONTH_SALES_MV" 6.312 KB 48 rows
. . exported "SH"."CHANNELS" 7.25 KB 5 rows
. . exported "SH"."COUNTRIES" 10.20 KB 23 rows
. . exported "SH"."PRODUCTS" 26.17 KB 72 rows
. . exported "SH"."COSTS":"COSTS_1995" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_1996" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_H1_1997" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_H2_1997" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_Q1_2002" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_Q1_2003" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_Q2_2002" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_Q2_2003" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_Q3_2002" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_Q3_2003" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_Q4_2002" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_Q4_2003" 0 KB 0 rows
. . exported "SH"."DIMENSION_EXCEPTIONS" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_1995" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_1996" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_H1_1997" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_H2_1997" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_Q1_2002" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_Q1_2003" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_Q2_2002" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_Q2_2003" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_Q3_2002" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_Q3_2003" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_Q4_2002" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_Q4_2003" 0 KB 0 rows
Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:
/home/oracle/dumpfile/shplus.dmp
Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at 11:54:17
共用44秒
排除统计信息导出：
[oracle@hadoop01 dumpfile]$ expdp system/oracle directory=dmpdir dumpfile=sh.dmp logfile=sh.log schemas=sh exclude=STATISTICS
Export: Release 11.2.0.3.0 - Production on Tue Jul 26 11:52:00 2016
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, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/******** directory=dmpdir dumpfile=sh.dmp logfile=sh.log schemas=sh exclude=STATISTICS
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 273.8 MB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/BITMAP_INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/INDEX/DOMAIN_INDEX/INDEX
Processing object type SCHEMA_EXPORT/MATERIALIZED_VIEW
Processing object type SCHEMA_EXPORT/DIMENSION
. . exported "SH"."CUSTOMERS" 9.853 MB 55500 rows
. . exported "SH"."COSTS":"COSTS_Q1_1998" 139.5 KB 4411 rows
. . exported "SH"."COSTS":"COSTS_Q1_1999" 183.5 KB 5884 rows
. . exported "SH"."COSTS":"COSTS_Q1_2000" 120.6 KB 3772 rows
. . exported "SH"."COSTS":"COSTS_Q1_2001" 227.8 KB 7328 rows
. . exported "SH"."COSTS":"COSTS_Q2_1998" 79.52 KB 2397 rows
. . exported "SH"."COSTS":"COSTS_Q2_1999" 132.5 KB 4179 rows
. . exported "SH"."COSTS":"COSTS_Q2_2000" 119.0 KB 3715 rows
. . exported "SH"."COSTS":"COSTS_Q2_2001" 184.5 KB 5882 rows
. . exported "SH"."COSTS":"COSTS_Q3_1998" 131.1 KB 4129 rows
. . exported "SH"."COSTS":"COSTS_Q3_1999" 137.3 KB 4336 rows
. . exported "SH"."COSTS":"COSTS_Q3_2000" 151.4 KB 4798 rows
. . exported "SH"."COSTS":"COSTS_Q3_2001" 234.4 KB 7545 rows
. . exported "SH"."COSTS":"COSTS_Q4_1998" 144.7 KB 4577 rows
. . exported "SH"."COSTS":"COSTS_Q4_1999" 159.0 KB 5060 rows
. . exported "SH"."COSTS":"COSTS_Q4_2000" 160.2 KB 5088 rows
. . exported "SH"."COSTS":"COSTS_Q4_2001" 278.4 KB 9011 rows
. . exported "SH"."SALES":"SALES_Q1_1998" 1.412 MB 43687 rows
. . exported "SH"."SALES":"SALES_Q1_1999" 2.071 MB 64186 rows
. . exported "SH"."SALES":"SALES_Q1_2000" 2.012 MB 62197 rows
. . exported "SH"."SALES":"SALES_Q1_2001" 1.965 MB 60608 rows
. . exported "SH"."SALES":"SALES_Q2_1998" 1.160 MB 35758 rows
. . exported "SH"."SALES":"SALES_Q2_1999" 1.754 MB 54233 rows
. . exported "SH"."SALES":"SALES_Q2_2000" 1.802 MB 55515 rows
. . exported "SH"."SALES":"SALES_Q2_2001" 2.051 MB 63292 rows
. . exported "SH"."SALES":"SALES_Q3_1998" 1.633 MB 50515 rows
. . exported "SH"."SALES":"SALES_Q3_1999" 2.166 MB 67138 rows
. . exported "SH"."SALES":"SALES_Q3_2000" 1.909 MB 58950 rows
. . exported "SH"."SALES":"SALES_Q3_2001" 2.130 MB 65769 rows
. . exported "SH"."SALES":"SALES_Q4_1998" 1.581 MB 48874 rows
. . exported "SH"."SALES":"SALES_Q4_1999" 2.014 MB 62388 rows
. . exported "SH"."SALES":"SALES_Q4_2000" 1.814 MB 55984 rows
. . exported "SH"."SALES":"SALES_Q4_2001" 2.257 MB 69749 rows
. . exported "SH"."SUPPLEMENTARY_DEMOGRAPHICS" 697.3 KB 4500 rows
. . exported "SH"."FWEEK_PSCAT_SALES_MV" 419.8 KB 11266 rows
. . exported "SH"."PROMOTIONS" 58.89 KB 503 rows
. . exported "SH"."TIMES" 380.8 KB 1826 rows
. . exported "SH"."CAL_MONTH_SALES_MV" 6.312 KB 48 rows
. . exported "SH"."CHANNELS" 7.25 KB 5 rows
. . exported "SH"."COUNTRIES" 10.20 KB 23 rows
. . exported "SH"."PRODUCTS" 26.17 KB 72 rows
. . exported "SH"."COSTS":"COSTS_1995" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_1996" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_H1_1997" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_H2_1997" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_Q1_2002" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_Q1_2003" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_Q2_2002" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_Q2_2003" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_Q3_2002" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_Q3_2003" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_Q4_2002" 0 KB 0 rows
. . exported "SH"."COSTS":"COSTS_Q4_2003" 0 KB 0 rows
. . exported "SH"."DIMENSION_EXCEPTIONS" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_1995" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_1996" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_H1_1997" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_H2_1997" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_Q1_2002" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_Q1_2003" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_Q2_2002" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_Q2_2003" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_Q3_2002" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_Q3_2003" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_Q4_2002" 0 KB 0 rows
. . exported "SH"."SALES":"SALES_Q4_2003" 0 KB 0 rows
Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:
/home/oracle/dumpfile/sh.dmp
Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at 11:53:01
共用61秒。
不包含统计信息导入，然后手动手机统计信息：
[oracle@hadoop01 dumpfile]$ impdp system/oracle directory=dmpdir dumpfile=sh.dmp logfile=sh.log schemas=sh
Import: Release 11.2.0.3.0 - Production on Tue Jul 26 11:57:40 2016
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, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_SCHEMA_01": system/******** directory=dmpdir dumpfile=sh.dmp logfile=sh.log schemas=sh
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "SH"."CUSTOMERS" 9.853 MB 55500 rows
. . imported "SH"."COSTS":"COSTS_Q1_1998" 139.5 KB 4411 rows
. . imported "SH"."COSTS":"COSTS_Q1_1999" 183.5 KB 5884 rows
. . imported "SH"."COSTS":"COSTS_Q1_2000" 120.6 KB 3772 rows
. . imported "SH"."COSTS":"COSTS_Q1_2001" 227.8 KB 7328 rows
. . imported "SH"."COSTS":"COSTS_Q2_1998" 79.52 KB 2397 rows
. . imported "SH"."COSTS":"COSTS_Q2_1999" 132.5 KB 4179 rows
. . imported "SH"."COSTS":"COSTS_Q2_2000" 119.0 KB 3715 rows
. . imported "SH"."COSTS":"COSTS_Q2_2001" 184.5 KB 5882 rows
. . imported "SH"."COSTS":"COSTS_Q3_1998" 131.1 KB 4129 rows
. . imported "SH"."COSTS":"COSTS_Q3_1999" 137.3 KB 4336 rows
. . imported "SH"."COSTS":"COSTS_Q3_2000" 151.4 KB 4798 rows
. . imported "SH"."COSTS":"COSTS_Q3_2001" 234.4 KB 7545 rows
. . imported "SH"."COSTS":"COSTS_Q4_1998" 144.7 KB 4577 rows
. . imported "SH"."COSTS":"COSTS_Q4_1999" 159.0 KB 5060 rows
. . imported "SH"."COSTS":"COSTS_Q4_2000" 160.2 KB 5088 rows
. . imported "SH"."COSTS":"COSTS_Q4_2001" 278.4 KB 9011 rows
. . imported "SH"."SALES":"SALES_Q1_1998" 1.412 MB 43687 rows
. . imported "SH"."SALES":"SALES_Q1_1999" 2.071 MB 64186 rows
. . imported "SH"."SALES":"SALES_Q1_2000" 2.012 MB 62197 rows
. . imported "SH"."SALES":"SALES_Q1_2001" 1.965 MB 60608 rows
. . imported "SH"."SALES":"SALES_Q2_1998" 1.160 MB 35758 rows
. . imported "SH"."SALES":"SALES_Q2_1999" 1.754 MB 54233 rows
. . imported "SH"."SALES":"SALES_Q2_2000" 1.802 MB 55515 rows
. . imported "SH"."SALES":"SALES_Q2_2001" 2.051 MB 63292 rows
. . imported "SH"."SALES":"SALES_Q3_1998" 1.633 MB 50515 rows
. . imported "SH"."SALES":"SALES_Q3_1999" 2.166 MB 67138 rows
. . imported "SH"."SALES":"SALES_Q3_2000" 1.909 MB 58950 rows
. . imported "SH"."SALES":"SALES_Q3_2001" 2.130 MB 65769 rows
. . imported "SH"."SALES":"SALES_Q4_1998" 1.581 MB 48874 rows
. . imported "SH"."SALES":"SALES_Q4_1999" 2.014 MB 62388 rows
. . imported "SH"."SALES":"SALES_Q4_2000" 1.814 MB 55984 rows
. . imported "SH"."SALES":"SALES_Q4_2001" 2.257 MB 69749 rows
. . imported "SH"."SUPPLEMENTARY_DEMOGRAPHICS" 697.3 KB 4500 rows
. . imported "SH"."FWEEK_PSCAT_SALES_MV" 419.8 KB 11266 rows
. . imported "SH"."PROMOTIONS" 58.89 KB 503 rows
. . imported "SH"."TIMES" 380.8 KB 1826 rows
. . imported "SH"."CAL_MONTH_SALES_MV" 6.312 KB 48 rows
. . imported "SH"."CHANNELS" 7.25 KB 5 rows
. . imported "SH"."COUNTRIES" 10.20 KB 23 rows
. . imported "SH"."PRODUCTS" 26.17 KB 72 rows
. . imported "SH"."COSTS":"COSTS_1995" 0 KB 0 rows
. . imported "SH"."COSTS":"COSTS_1996" 0 KB 0 rows
. . imported "SH"."COSTS":"COSTS_H1_1997" 0 KB 0 rows
. . imported "SH"."COSTS":"COSTS_H2_1997" 0 KB 0 rows
. . imported "SH"."COSTS":"COSTS_Q1_2002" 0 KB 0 rows
. . imported "SH"."COSTS":"COSTS_Q1_2003" 0 KB 0 rows
. . imported "SH"."COSTS":"COSTS_Q2_2002" 0 KB 0 rows
. . imported "SH"."COSTS":"COSTS_Q2_2003" 0 KB 0 rows
. . imported "SH"."COSTS":"COSTS_Q3_2002" 0 KB 0 rows
. . imported "SH"."COSTS":"COSTS_Q3_2003" 0 KB 0 rows
. . imported "SH"."COSTS":"COSTS_Q4_2002" 0 KB 0 rows
. . imported "SH"."COSTS":"COSTS_Q4_2003" 0 KB 0 rows
. . imported "SH"."DIMENSION_EXCEPTIONS" 0 KB 0 rows
. . imported "SH"."SALES":"SALES_1995" 0 KB 0 rows
. . imported "SH"."SALES":"SALES_1996" 0 KB 0 rows
. . imported "SH"."SALES":"SALES_H1_1997" 0 KB 0 rows
. . imported "SH"."SALES":"SALES_H2_1997" 0 KB 0 rows
. . imported "SH"."SALES":"SALES_Q1_2002" 0 KB 0 rows
. . imported "SH"."SALES":"SALES_Q1_2003" 0 KB 0 rows
. . imported "SH"."SALES":"SALES_Q2_2002" 0 KB 0 rows
. . imported "SH"."SALES":"SALES_Q2_2003" 0 KB 0 rows
. . imported "SH"."SALES":"SALES_Q3_2002" 0 KB 0 rows
. . imported "SH"."SALES":"SALES_Q3_2003" 0 KB 0 rows
. . imported "SH"."SALES":"SALES_Q4_2002" 0 KB 0 rows
. . imported "SH"."SALES":"SALES_Q4_2003" 0 KB 0 rows
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/BITMAP_INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/INDEX/DOMAIN_INDEX/INDEX
Processing object type SCHEMA_EXPORT/MATERIALIZED_VIEW
Processing object type SCHEMA_EXPORT/DIMENSION
Job "SYSTEM"."SYS_IMPORT_SCHEMA_01" successfully completed at 11:58:17
共用37秒
收集统计信息9秒，一共9+37=46秒。
包含统计信息导入:
[oracle@hadoop01 dumpfile]$ impdp system/oracle directory=dmpdir dumpfile=shplus.dmp logfile=shplus.log schemas=sh
Import: Release 11.2.0.3.0 - Production on Tue Jul 26 12:03:08 2016
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, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_SCHEMA_01": system/******** directory=dmpdir dumpfile=shplus.dmp logfile=shplus.log schemas=sh
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "SH"."CUSTOMERS" 9.853 MB 55500 rows
. . imported "SH"."COSTS":"COSTS_Q1_1998" 139.5 KB 4411 rows
. . imported "SH"."COSTS":"COSTS_Q1_1999" 183.5 KB 5884 rows
. . imported "SH"."COSTS":"COSTS_Q1_2000" 120.6 KB 3772 rows
. . imported "SH"."COSTS":"COSTS_Q1_2001" 227.8 KB 7328 rows
. . imported "SH"."COSTS":"COSTS_Q2_1998" 79.52 KB 2397 rows
. . imported "SH"."COSTS":"COSTS_Q2_1999" 132.5 KB 4179 rows
. . imported "SH"."COSTS":"COSTS_Q2_2000" 119.0 KB 3715 rows
. . imported "SH"."COSTS":"COSTS_Q2_2001" 184.5 KB 5882 rows
. . imported "SH"."COSTS":"COSTS_Q3_1998" 131.1 KB 4129 rows
. . imported "SH"."COSTS":"COSTS_Q3_1999" 137.3 KB 4336 rows
. . imported "SH"."COSTS":"COSTS_Q3_2000" 151.4 KB 4798 rows
. . imported "SH"."COSTS":"COSTS_Q3_2001" 234.4 KB 7545 rows
. . imported "SH"."COSTS":"COSTS_Q4_1998" 144.7 KB 4577 rows
. . imported "SH"."COSTS":"COSTS_Q4_1999" 159.0 KB 5060 rows
. . imported "SH"."COSTS":"COSTS_Q4_2000" 160.2 KB 5088 rows
. . imported "SH"."COSTS":"COSTS_Q4_2001" 278.4 KB 9011 rows
. . imported "SH"."SALES":"SALES_Q1_1998" 1.412 MB 43687 rows
. . imported "SH"."SALES":"SALES_Q1_1999" 2.071 MB 64186 rows
. . imported "SH"."SALES":"SALES_Q1_2000" 2.012 MB 62197 rows
. . imported "SH"."SALES":"SALES_Q1_2001" 1.965 MB 60608 rows
. . imported "SH"."SALES":"SALES_Q2_1998" 1.160 MB 35758 rows
. . imported "SH"."SALES":"SALES_Q2_1999" 1.754 MB 54233 rows
. . imported "SH"."SALES":"SALES_Q2_2000" 1.802 MB 55515 rows
. . imported "SH"."SALES":"SALES_Q2_2001" 2.051 MB 63292 rows
. . imported "SH"."SALES":"SALES_Q3_1998" 1.633 MB 50515 rows
. . imported "SH"."SALES":"SALES_Q3_1999" 2.166 MB 67138 rows
. . imported "SH"."SALES":"SALES_Q3_2000" 1.909 MB 58950 rows
. . imported "SH"."SALES":"SALES_Q3_2001" 2.130 MB 65769 rows
. . imported "SH"."SALES":"SALES_Q4_1998" 1.581 MB 48874 rows
. . imported "SH"."SALES":"SALES_Q4_1999" 2.014 MB 62388 rows
. . imported "SH"."SALES":"SALES_Q4_2000" 1.814 MB 55984 rows
. . imported "SH"."SALES":"SALES_Q4_2001" 2.257 MB 69749 rows
. . imported "SH"."SUPPLEMENTARY_DEMOGRAPHICS" 697.3 KB 4500 rows
. . imported "SH"."FWEEK_PSCAT_SALES_MV" 419.8 KB 11266 rows
. . imported "SH"."PROMOTIONS" 58.89 KB 503 rows
. . imported "SH"."TIMES" 380.8 KB 1826 rows
. . imported "SH"."CAL_MONTH_SALES_MV" 6.312 KB 48 rows
. . imported "SH"."CHANNELS" 7.25 KB 5 rows
. . imported "SH"."COUNTRIES" 10.20 KB 23 rows
. . imported "SH"."PRODUCTS" 26.17 KB 72 rows
. . imported "SH"."COSTS":"COSTS_1995" 0 KB 0 rows
. . imported "SH"."COSTS":"COSTS_1996" 0 KB 0 rows
. . imported "SH"."COSTS":"COSTS_H1_1997" 0 KB 0 rows
. . imported "SH"."COSTS":"COSTS_H2_1997" 0 KB 0 rows
. . imported "SH"."COSTS":"COSTS_Q1_2002" 0 KB 0 rows
. . imported "SH"."COSTS":"COSTS_Q1_2003" 0 KB 0 rows
. . imported "SH"."COSTS":"COSTS_Q2_2002" 0 KB 0 rows
. . imported "SH"."COSTS":"COSTS_Q2_2003" 0 KB 0 rows
. . imported "SH"."COSTS":"COSTS_Q3_2002" 0 KB 0 rows
. . imported "SH"."COSTS":"COSTS_Q3_2003" 0 KB 0 rows
. . imported "SH"."COSTS":"COSTS_Q4_2002" 0 KB 0 rows
. . imported "SH"."COSTS":"COSTS_Q4_2003" 0 KB 0 rows
. . imported "SH"."DIMENSION_EXCEPTIONS" 0 KB 0 rows
. . imported "SH"."SALES":"SALES_1995" 0 KB 0 rows
. . imported "SH"."SALES":"SALES_1996" 0 KB 0 rows
. . imported "SH"."SALES":"SALES_H1_1997" 0 KB 0 rows
. . imported "SH"."SALES":"SALES_H2_1997" 0 KB 0 rows
. . imported "SH"."SALES":"SALES_Q1_2002" 0 KB 0 rows
. . imported "SH"."SALES":"SALES_Q1_2003" 0 KB 0 rows
. . imported "SH"."SALES":"SALES_Q2_2002" 0 KB 0 rows
. . imported "SH"."SALES":"SALES_Q2_2003" 0 KB 0 rows
. . imported "SH"."SALES":"SALES_Q3_2002" 0 KB 0 rows
. . imported "SH"."SALES":"SALES_Q3_2003" 0 KB 0 rows
. . imported "SH"."SALES":"SALES_Q4_2002" 0 KB 0 rows
. . imported "SH"."SALES":"SALES_Q4_2003" 0 KB 0 rows
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/BITMAP_INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/BITMAP_INDEX/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/INDEX/DOMAIN_INDEX/INDEX
Processing object type SCHEMA_EXPORT/MATERIALIZED_VIEW
Processing object type SCHEMA_EXPORT/DIMENSION
Job "SYSTEM"."SYS_IMPORT_SCHEMA_01" successfully completed at 12:03:52
共44秒。
可见oracle11.2.0.4版本中导入dump数据包含统计信息并不会对性能造成很大影响。
版权声明：本文为u011478909原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。