oracle expdp中的parallel

1,先使用expdp parallel导出文件[@more@]

C:UsersFounder>expdp xxxx/founder2012 directory=temp_dir dumpfile=xxxx_%U.dmp parallel=3

Export: Release 11.2.0.1.0 - Production on 星期五 3月 8 09:48:53 2013

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
启动 "xxxx"."SYS_EXPORT_SCHEMA_01": xxxx/******** directory=temp_dir dumpfile=xxxx_%U.dmp parallel=3

正在使用 BLOCKS 方法进行估计...
处理对象类型 SCHEMA_EXPORT/TABLE/TABLE_DATA
使用 BLOCKS 方法的总估计: 1.375 MB
...................................................................
******************************************************************************
xxxx.SYS_EXPORT_SCHEMA_01 的转储文件集为:
D:xxxx_01.DMP

D:xxxx_02.DMP

D:xxxx_03.DMP

作业 "xxxx"."SYS_EXPORT_SCHEMA_01" 已于 09:50:21 成功完成

2,在impdp parallel导入

C:UsersFounder>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on 星期五 3月 8 09:50:56 2013

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


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

SQL> drop user xxxx cascade;

User dropped.

SQL> create user xxxx identified by founder2012;

User created.

SQL> alter user xxxx account unlock;

User altered.

SQL> grant connect,resource to xxxx;

Grant succeeded.

SQL> grant read,write on directory temp_dir to xxxx;

Grant succeeded.

SQL> grant sysdba to xxxx;

grant sysdba to xxxx
*
ERROR at line 1:
ORA-01994: GRANT 失败: 口令文件缺失或已禁用


SQL> grant dba to xxxx;

Grant succeeded.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

C:UsersFounder>impdp xxxx/founder2012 directory=temp_dir file=xxxx_01.dmp,xxxx_02.dmp,xxxx_03.dmp

Import: Release 11.2.0.1.0 - Production on 星期五 3月 8 09:52:42 2013

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Legacy Mode Active due to the following parameters:
Legacy Mode Parameter: "file=xxxx_01.dmp,xxxx_02.dmp,xxxx_03.dmp" Location: Command Line, Replaced with: "dumpfile=xxxx

01.dmp,saas_02.dmp,saas_03.dmp"
已成功加载/卸载了主表 "xxxx"."SYS_IMPORT_FULL_01"

启动 "xxxx"."SYS_IMPORT_FULL_01": xxxx/******** directory=temp_dir dumpfile=xxxx_01.dmp,xxxx_02.dmp,xxxx_03.dmp

.....................................
处理对象类型 SCHEMA_EXPORT/TABLE/INDEX/INDEX
处理对象类型 SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
处理对象类型 SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
处理对象类型 SCHEMA_EXPORT/TABLE/COMMENT
处理对象类型 SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
作业 "xxxx"."SYS_IMPORT_FULL_01" 已于 09:53:06 成功完成

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24237320/viewspace-1060270/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24237320/viewspace-1060270/