impdp network_link

impdp network_link[@more@]

C:Userswlcsp>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on 星期一 11月 18 11:49:50 2013

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

连接到:
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> grant create database link to wlcsp;

授权成功。
SQL> conn wlcsp/wlcsp123
已连接。
SQL> create database link primary connect to wlcsp identified by wlcsp123 using
'primary';

C:Userswlcsp>impdp wlcsp/wlcsp123 network_link=primary

Import: Release 11.2.0.1.0 - Production on 星期一 11月 18 11:50:28 2013

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

连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Produc
tion
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: 操作无效
ORA-39070: 无法打开日志文件。
ORA-39145: 必须指定目录对象参数且不能为空

C:Userswlcsp>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on 星期一 11月 18 12:17:01 2013

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

连接到:
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> create directory temp_dir as 'c:';

目录已创建。

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

授权成功。

C:Userswlcsp>impdp wlcsp/wlcsp123 directory=temp_dir network_link=primary

Import: Release 11.2.0.1.0 - Production on 星期一 11月 18 12:17:35 2013

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

连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Produc
tion
With the Partitioning, OLAP, Data Mining and Real Application Testing options
启动 "WLCSP"."SYS_IMPORT_SCHEMA_01": wlcsp/******** directory=temp_dir network_
link=primary
正在使用 BLOCKS 方法进行估计...
处理对象类型 SCHEMA_EXPORT/TABLE/TABLE_DATA
使用 BLOCKS 方法的总估计: 65.93 MB
处理对象类型 SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
处理对象类型 SCHEMA_EXPORT/SEQUENCE/SEQUENCE
处理对象类型 SCHEMA_EXPORT/TABLE/TABLE
..................................................
处理对象类型 SCHEMA_EXPORT/TABLE/INDEX/INDEX
处理对象类型 SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
处理对象类型 SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
处理对象类型 SCHEMA_EXPORT/TABLE/COMMENT
处理对象类型 SCHEMA_EXPORT/PROCEDURE/PROCEDURE
处理对象类型 SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
处理对象类型 SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
作业 "xxxx"."SYS_IMPORT_SCHEMA_01" 已于 12:18:53 成功完成

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

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