Local use IMPDP export server dump file, local use IMPDP to import remote database user

Source: Internet
Author: User
Tags create directory

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.