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 成功完成

oracle expdp中的parallel

相關文章