Use IMPDP to export server dump files locally, use IMPDP to import remote database users locally
1) EXPDP is a 2 of the dump files that can be generated on the client) IMPDP is a migration copy of the data that can be performed between different instances 1:1) The remote database WSJB user is exported to the local disk by using the EXPDP command under the D:\ Microsoft Windows [version 6.1.7600] Copyright (c) Microsoft Corporation. All rights reserved. C:\windows\system32>
Sqlplus System/systemSql*plus:release 11.1.0.6.0-production on Thu January 13:49:34 Copyright (c) 1982, Oracle. All rights reserved. Connect to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0-productionwith The partitioning, OLAP, Data Mining and Re Al Application Testing Options sql>
input
1 Create Public database link WSJB
2 Connect to WSJB identified by Wsjbcs
3 using ' xagxsi_16 ';The database link was created. Sql>
Select 1 from [email protected];1----------1 sql>
Create directory Chenzw as ' d:\ ';The catalog has been created. Sql>
Grant Read,write on directory CHENZW to public;Authorization is successful. Sql>
commit;Submit complete. Sql>
EXPDP system/[email protected] directory = CHENZW dumpfile=wsjb20130110.dmp network_link=wsjb logfile= Exp20130110.log SCHEMAS=WSJB from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0-productionwith The partitioning, OLAP, Data Mini NG and Real Application testing options Disconnect  C:\WINDOWS\SYSTEM32>EXPDP system/[email protected] directory = CHENZW dumpfile=wsjb20130110.dmp NETWORK_LINK=WSJB Logfile=exp20130110.log schemas=wsjb export:release 11.1.0.6.0-production on Thursday, 10 January, 13:54:23 copyright (c) 2003, Oracle. all rights reserved. connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0-productionwith the Partit Ioning, OLAP, Data Mining and Real Application testing options Start "SYSTEM". " Sys_export_schema_01 ": system/******** @orcl directory = CHENZW dumpfile=wsjb20130110.dmp NETWORK_LINK=WSJB Logfile=exp20130110.log schemas=wsjb is using the BLOCKS method to estimate ... Processing object Type Schema_export/table/table_data Total estimate using the BLOCKS method: 93.31 MB Processing object Type Schema_export/user processing object type Schema_export/system_ Grant handles object types Schema_export/role_grant object Types Schema_export/default_roleWorking with Object types Schema_export/tablespace_quota handling object types Schema_export/pre_schema/procact_schema handling object Types schema_export/synonym/ Synonym handles object types Schema_export/sequence/sequence handles object types schema_export/table/table handles object types schema_export/table/index/ INDEX handles object types Schema_export/table/constraint/constraint object Types Schema_export/table/index/statistics/index_ Statistics handles object types Schema_export/table/comment handles object types Schema_export/package/package_spec handles object types schema_export/ Function/function Handling Object Types Schema_export/package/compile_package/package_spec/alter_package_spec handling object Types SCHEMA_ Export/function/alter_function Processing Object Types Schema_euse IMPDP to export server dump files locally, use IMPDP to import remote database users locally
1) EXPDP is a 2 of the dump files that can be generated on the client) IMPDP is a migration copy of the data that can be performed between different instances 1:1) The remote database WSJB user is exported to the local disk by using the EXPDP command under the D:\ Microsoft Windows [version 6.1.7600] Copyright (c) Microsoft Corporation. All rights reserved. C:\windows\system32>
Sqlplus System/systemSql*plus:release 11.1.0.6.0-production on Thu January 13:49:34 Copyright (c) 1982, Oracle. All rights reserved. Connect to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0-productionwith The partitioning, OLAP, Data Mining and Re Al Application Testing Options sql>
input
1 Create Public database link WSJB
2 Connect to WSJB identified by Wsjbcs
3 using ' xagxsi_16 ';The database link was created. Sql>
Select 1 from [email protected];1----------1 sql>
Create directory Chenzw as ' d:\ ';The catalog has been created. Sql>
Grant Read,write on directory CHENZW to public;Authorization is successful. Sql>
commit;Submit complete. Sql>
EXPDP system/[email protected] directory = CHENZW dumpfile=wsjb20130110.dmp network_link=wsjb logfile= Exp20130110.log SCHEMAS=WSJB from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0-productionwith The partitioning, OLAP, Data Mini NG and Real Application testing options Disconnect  C:\WINDOWS\SYSTEM32>EXPDP system/[email protected] directory = CHENZW dumpfile=wsjb20130110.dmp NETWORK_LINK=WSJB Logfile=exp20130110.log schemas=wsjb export:release 11.1.0.6.0-production on Thursday, 10 January, 13:54:23 copyright (c) 2003, Oracle. all rights reserved. connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0-productionwith the Partit Ioning, OLAP, Data Mining and Real Application testing options Start "SYSTEM". " Sys_export_schema_01 ": system/******** @orcl directory = CHENZW dumpfile=wsjb20130110.dmp NETWORK_LINK=WSJB Logfile=exp20130110.log schemas=wsjb is using the BLOCKS method to estimate ... Processing object Type Schema_export/table/table_data Total estimate using the BLOCKS method: 93.31 MB Processing object Type Schema_export/user processing object type Schema_export/system_ Grant handles object types Schema_export/role_grant object Types Schema_export/default_roleWorking with Object types Schema_export/tablespace_quota handling object types Schema_export/pre_schema/procact_schema handling object Types schema_export/synonym/ Synonym handles object types Schema_export/sequence/sequence handles object types schema_export/table/table handles object types schema_export/table/index/ INDEX handles object types Schema_export/table/constraint/constraint object Types Schema_export/table/index/statistics/index_ Statistics handles object types Schema_export/table/comment handles object types Schema_export/package/package_spec handles object types schema_export/ Function/function Handling Object Types Schema_export/package/compile_package/package_spec/alter_package_spec handling object Types SCHEMA_ Export/function/alter_function Handling Object Types Schema_export/view/view handling object types schema_export/package/package_body handling object types Schema_export/table/constraint/ref_constraint Handling Object Types Schema_export/table/trigger handling object Types schema_export/table/ Statistics/table_statistics. . "WSJB" was exported. " IRAA07 34.21 MB 5 Lines ... The main table "SYSTEM" has been successfully loaded/unloaded with n multiple rows omitted here. " Sys_export_schema_01 " ****SYSTEM. The sys_export_schema_01 dump file set is: D:\WSJB20130110. DMP Job "SYSTEM". " Sys_export_schema_01 "successfully completed at 14:04:08 Exercise 2:1) Import the remote database WSJB user to the local test user using the IMPDP command
IMPDP system/[email protected] Directory = CHENZW Network_link = WSJB schemas = wsjb remap_schema=wsjb:testXport/view/view Handling Object Types schema_export/package/package_body handling object Types Schema_export/table/constraint/ref_ Constraint handles object types Schema_export/table/trigger handles object type Schema_export/table/statistics/table_statistics. . "WSJB" was exported. " IRAA07 "34.21 MB 5 rows ... The main table "SYSTEM" has been successfully loaded/unloaded with n multiple rows omitted here. " Sys_export_schema_01 "******************************************************************************system. The sys_export_schema_01 dump file set is: D:\WSJB20130110. DMP Job "SYSTEM". " Sys_export_schema_01 "successfully completed exercise at 14:04:08 2:1) import the remote database WSJB user to the local test user using the IMPDP command
IMPDP system/[email protected] Directory = CHENZW Network_link = WSJB schemas = wsjb remap_schema=wsjb:test
