IMPDP导入远程数据库

最新推荐文章于 2023-10-07 18:19:22 发布
最新推荐文章于 2023-10-07 18:19:22 发布
阅读量636 收藏
点赞数
文章标签： 数据库

这个功能在测试环境中较多使用。

-- 在目标库创建DBLINK后，通过IMPDP导入远程数据库到目标。
[oracle@dg dbbackup(01:13:06)]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Sun Sep 29 01:15:17 2013
Copyright (c) 1982, 2011, Oracle.  All rights reserved.

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

01:15:37 SYS@wailon> create public database link db_wailon connect to scott identified by tiger using 'wailon';

Database link created.

01:16:39 SYS@wailon> col name for a20
01:16:47 SYS@wailon> col host for a30
01:16:54 SYS@wailon> select name,userid,host from link$;

NAME                 USERID                         HOST
-------------------- ------------------------------ ------------------------------
OGG                  SCOTT                          ogg
DB_WAILON            SCOTT                          wailon

01:16:57 SYS@wailon> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

-- 使用IMPDP的NETWORK_LINK连接远程数据库，确保导入前存在相关的表空间，用户在导入时自动创建
-- NETWORK_LINK=远程数据库DBLINK_NAME，SCHEMAS=需要导入的用户，REMAP_SCHEMA=原SCHEMA:新SCHEMA
[oracle@dg dbbackup(01:18:22)]$ impdp scott/tiger network_link=db_wailon schemas=scott remap_schema=scott:wailon

Import: Release 11.2.0.3.0 - Production on Sun Sep 29 01:19:20 2013

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
FLASHBACK automatically enabled to preserve database integrity.
Starting "SCOTT"."SYS_IMPORT_SCHEMA_01":  scott/******** network_link=db_wailon schemas=scott remap_schema=scott:wailon
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 10.37 MB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
. . imported "WAILON"."GGS_DDL_HIST"                       2030 rows
. . imported "WAILON"."GGS_MARKER"                          829 rows
. . imported "WAILON"."CHECKPOINT"                            2 rows
. . imported "WAILON"."DEPT"                                  6 rows
. . imported "WAILON"."EMP"                                  18 rows
. . imported "WAILON"."GGS_DDL_HIST_ALT"                     71 rows
. . imported "WAILON"."GGS_SETUP"                             6 rows
. . imported "WAILON"."SALGRADE"                              5 rows
. . imported "WAILON"."BONUS"                                 0 rows
. . imported "WAILON"."CHECKPOINT_LOX"                        0 rows
. . imported "WAILON"."GGS_DDL_COLUMNS"                       0 rows
. . imported "WAILON"."GGS_DDL_LOG_GROUPS"                    0 rows
. . imported "WAILON"."GGS_DDL_OBJECTS"                       0 rows
. . imported "WAILON"."GGS_DDL_PARTITIONS"                    0 rows
. . imported "WAILON"."GGS_DDL_PRIMARY_KEYS"                  0 rows
. . imported "WAILON"."GGS_DDL_RULES"                         0 rows
. . imported "WAILON"."GGS_DDL_RULES_LOG"                     0 rows
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PROCEDURE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job "SCOTT"."SYS_IMPORT_SCHEMA_01" completed with 0 error(s) at 01:21:02

-- 检查是否导入成功
[oracle@dg dbbackup(01:26:42)]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Sun Sep 29 01:27:01 2013

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


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

01:26:50 WAILON@wailon> alter user wailon identified by wailon;

User altered.

01:27:02 WAILON@wailon> select table_name,tablespace_name from dba_tables where owner='WAILON';

TABLE_NAME                     TABLESPACE_NAME
------------------------------ ------------------------------
GGS_SETUP                      USERS
GGS_DDL_HIST_ALT               USERS
GGS_MARKER                     USERS
GGS_DDL_RULES                  USERS
GGS_DDL_RULES_LOG              USERS
CHECKPOINT                     USERS
CHECKPOINT_LOX                 USERS
DEPT                           USERS
EMP                            USERS
BONUS                          USERS
SALGRADE                       USERS
GGS_DDL_HIST                   USERS
GGS_DDL_COLUMNS                USERS
GGS_DDL_LOG_GROUPS             USERS
GGS_DDL_PARTITIONS             USERS
GGS_DDL_PRIMARY_KEYS           USERS
GGS_DDL_OBJECTS                USERS
GGS_TEMP_UK
GGS_STICK
GGS_TEMP_COLS

20 rows selected.

01:27:15 SYS@wailon> drop user wailon cascade;

User dropped.

01:29:53 SYS@wailon> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

-- 使用IMPDP导入到不同的用户不同的表空间，确保导入前存在相关的表空间
-- REMAP_TABLESPACE=原TABLESPACE:新TABLESPACE
[oracle@dg dbbackup(01:42:10)]$ impdp scott/tiger network_link=db_wailon remap_tablespace=users:wailon remap_schema=scott:wailon

Import: Release 11.2.0.3.0 - Production on Sun Sep 29 01:42:28 2013

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
FLASHBACK automatically enabled to preserve database integrity.
Starting "SCOTT"."SYS_IMPORT_SCHEMA_01":  scott/******** network_link=db_wailon remap_tablespace=users:wailon remap_schema=scott:wailon
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 12.37 MB
Processing object type SCHEMA_EXPORT/USER
ORA-39083: Object type USER failed to create with error:
ORA-00959: tablespace 'WAILON' does not exist
Failing sql is:
 CREATE USER "WAILON" IDENTIFIED BY VALUES 'S:757B41B311870958859653625C627A2D72CCED18785157E6D6AD16F95A9D;F894844C34402B67' DEFAULT TABLESPACE "WAILON" TEMPORARY TABLESPACE "TEMP01"
-- 表空间不存在时报错

-- 建立需要的表空间
[oracle@dg dbbackup(02:01:03)]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Sun Sep 29 02:01:10 2013

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


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

02:06:39 SYS@wailon> create tablespace wailon datafile size 100m;

Tablespace created.

02:07:00 SYS@wailon> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

-- 重新导入
[oracle@dg dbbackup(02:07:03)]$ impdp scott/tiger network_link=db_wailon remap_tablespace=users:wailon remap_schema=scott:wailon

Import: Release 11.2.0.3.0 - Production on Sun Sep 29 02:07:05 2013

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
FLASHBACK automatically enabled to preserve database integrity.
Starting "SCOTT"."SYS_IMPORT_SCHEMA_01":  scott/******** network_link=db_wailon remap_tablespace=users:wailon remap_schema=scott:wailon
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 13.37 MB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
. . imported "WAILON"."GGS_DDL_HIST"                       2534 rows
. . imported "WAILON"."GGS_MARKER"                         1435 rows
. . imported "WAILON"."CHECKPOINT"                            2 rows
. . imported "WAILON"."DEPT"                                  6 rows
. . imported "WAILON"."EMP"                                  18 rows
. . imported "WAILON"."GGS_DDL_HIST_ALT"                    123 rows
. . imported "WAILON"."GGS_SETUP"                             6 rows
. . imported "WAILON"."SALGRADE"                              5 rows
. . imported "WAILON"."BONUS"                                 0 rows
. . imported "WAILON"."CHECKPOINT_LOX"                        0 rows
. . imported "WAILON"."GGS_DDL_COLUMNS"                       0 rows
. . imported "WAILON"."GGS_DDL_LOG_GROUPS"                    0 rows
. . imported "WAILON"."GGS_DDL_OBJECTS"                       0 rows
. . imported "WAILON"."GGS_DDL_PARTITIONS"                    0 rows
. . imported "WAILON"."GGS_DDL_PRIMARY_KEYS"                  0 rows
. . imported "WAILON"."GGS_DDL_RULES"                         0 rows
. . imported "WAILON"."GGS_DDL_RULES_LOG"                     0 rows
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PROCEDURE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job "SCOTT"."SYS_IMPORT_SCHEMA_01" completed with 0 error(s) at 02:08:57

-- 检查是否导入成功
[oracle@dg dbbackup(02:09:03)]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Sun Sep 29 02:09:26 2013

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


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

02:09:26 SYS@wailon> alter user wailon identified by wailon;

User altered.

02:09:43 SYS@wailon> conn wailon/wailon
Connected.
02:09:47 WAILON@wailon> select * from tab;

TNAME                          TABTYPE  CLUSTERID
------------------------------ ------- ----------
BONUS                          TABLE
CHECKPOINT                     TABLE
CHECKPOINT_LOX                 TABLE
DEPT                           TABLE
EMP                            TABLE
GGS_DDL_COLUMNS                TABLE
GGS_DDL_HIST                   TABLE
GGS_DDL_HIST_ALT               TABLE
GGS_DDL_LOG_GROUPS             TABLE
GGS_DDL_OBJECTS                TABLE
GGS_DDL_PARTITIONS             TABLE
GGS_DDL_PRIMARY_KEYS           TABLE
GGS_DDL_RULES                  TABLE
GGS_DDL_RULES_LOG              TABLE
GGS_MARKER                     TABLE
GGS_SETUP                      TABLE
GGS_STICK                      TABLE
GGS_TEMP_COLS                  TABLE
GGS_TEMP_UK                    TABLE
SALGRADE                       TABLE

20 rows selected.

02:09:51 WAILON@wailon> select tablespace_name,table_name from dba_tables where owner='WAILON';

TABLESPACE_NAME                TABLE_NAME
------------------------------ ------------------------------
WAILON                         GGS_SETUP
WAILON                         GGS_DDL_HIST_ALT
WAILON                         GGS_MARKER
WAILON                         GGS_DDL_RULES
WAILON                         GGS_DDL_RULES_LOG
WAILON                         CHECKPOINT
WAILON                         CHECKPOINT_LOX
WAILON                         DEPT
WAILON                         EMP
WAILON                         BONUS
WAILON                         SALGRADE
WAILON                         GGS_DDL_HIST
WAILON                         GGS_DDL_COLUMNS
WAILON                         GGS_DDL_LOG_GROUPS
WAILON                         GGS_DDL_PARTITIONS
WAILON                         GGS_DDL_PRIMARY_KEYS
WAILON                         GGS_DDL_OBJECTS
                               GGS_TEMP_UK
                               GGS_STICK
                               GGS_TEMP_COLS

20 rows selected.

02:10:09 WAILON@wailon> set long 4000

02:10:50 WAILON@wailon> select dbms_metadata.get_ddl('TABLE','GGS_TEMP_UK') FROM dual;

DBMS_METADATA.GET_DDL('TABLE','GGS_TEMP_UK')
--------------------------------------------------------------------------------

  CREATE GLOBAL TEMPORARY TABLE "WAILON"."GGS_TEMP_UK"
   (    "SEQNO" NUMBER NOT NULL ENABLE,
        "KEYNAME" VARCHAR2(100),
        "COLNAME" VARCHAR2(100),
        "NULLABLE" NUMBER,
        "VIRTUAL" NUMBER,
        "UDT" NUMBER,
        "ISSYS" NUMBER,
         PRIMARY KEY ("SEQNO", "KEYNAME", "COLNAME") ENABLE
   ) ON COMMIT DELETE ROWS

-- 临时表只是数据字典定义，只在使用时才会使用临时表空间

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

转载于:http://blog.itpub.net/429786/viewspace-776617/

cuiwu7783
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
impdp远程导入oracle数据库,impdp导入远程数据库
weixin_31880383的博客
04-04 1739
使用expdp(非本地)远程导出数据背景：前段时间，需要从异地一个测试数据库中将测试数据(一张表)导入本地库，表数据量大约500万，字段160多个，开始用了exp/imp方式，速度奇慢，不能忍，于是转而使用expdp/impdp方式。expdp/impd介绍：从10g开始，除了传统的exp/imp导入导出工具外，Oracle...文章bisal2015-04-151100浏览量使用 EXPDP 远...
Oracle expdp-impdp 数据泵导入导出（远程）
Hjchidaozhe的博客
04-21 1574
1、登陆到用户 sqlplus 用户名/密码 sqlplus HADOOP/Mthgh456 2、创建逻辑目录用于导出导入数据（目录一定要真实存在） create or replace directory out_dir as 'C:\out'; --out_dir（逻辑目录名，可以随便取） 3、也可以将这个逻辑目录授权给其他用户 grant read,write on direc...
oracle数据泵impdp远程导入，无需生成dumpfile文件
03-11 6199
1.首先要在目标库上创建文件夹，创建的名称用于impdp的参数directory,注意指定的文件夹要存在 create or replace directory DMPDIR as 'd:\dmp'; grant read,write on directory DMPDIR to public;       2.在目标库上创建公共的连接源数据库的datalink，用于impdp的net
impdp导入mysql_IMPDP导入远程数据库
weixin_34450111的博客
01-19 525
这个功能在测试环境中较多使用。-- 在目标库创建DBLINK后，通过IMPDP导入远程数据库到目标。[oracle@dg dbbackup(01:13:06)]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Sun Sep 29 01:15:17 2013Copyright (c) 1982, 2011, Oracle...
将本地的dmp文件impdp导入远程数据库
05-24
可以使用Oracle提供的impdp命令将本地的dmp文件导入远程数据库。以下是基本的导入命令： ``` impdp username/password@remote_database_name directory=local_directory_name dumpfile=local_dmp_file_name network...
本地使用impdp导出服务器转储文件,本地使用impdp导入远程数据库用户
似水流年
01-10 6470
1）expdp是可以在客户端上生成转储文件的 2）impdp是可以在不同的实例之间进行数据的迁移复制的 练习1： 1）将远程数据库WSJB用户使用expdp命令导出到本地磁盘的D:\下 Microsoft Windows [版本 6.1.7600] 版权所有 (c) 2009 Microsoft Corporation。保留所有权利。 C:\windows\
用impbp直接导入远程数据库
sinat_28527451的博客
08-08 802
1．需求 将一个远程系统数据库导入到本地 2．步骤 （1）在本地创建表空间和用户 （2）在本服务器创建源数据库账户的tns （3）登录源数据库，查询Oracle版本号 （4）登录system用户，创建network_link （5）退出sqlplus，直接在命令提示符程序中输入impdp语句，进行数据库的直接导入 3．实例 （1）基本信息本地数据库信息 用户： local
【EXPDP】expdp/impdp数据泵远程导入导出
zclinux的博客
11-24 1万+
Oracle在10g的时候有一个很好用的导出工具expdp（数据泵） 但是这个工具好用的同时，有一个局限，就是必须用本地的用户才可以导出数据，也就是说数据泵只能导出本地数据库的数据 但是如果业务需求是   将一个用户的全部表都导出，但是不需要t1,t2,t3而且这个数据库不是本地的，是异地的一个数据库 正常的思路是通过exp userxx/passwd@192.168.1.100/orcl
使用expdp和impdp远程导入导出库
热门推荐
申公的专栏
01-16 1万+
使用expdb ，impdp 导入导出库，首先在本地必须建立db_link才可导入导出，exp,imp 这两个命令无需建立db_link即可导入导出。 一.远程导出库的步骤： 1.在本地库的配置文件中加如配置： tnames.ora增加 orcl = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
从服务器导出数据库文件到本地,当地使用impdp导出服务器转储文件,本地使用impdp导入远程数据库用户...
weixin_35735370的博客
08-04 432
Microsoft Windows [版本 6.1.7600]版权所有 (c) 2009 Microsoft Corporation。保留所有权利。C:\windows\system32>sqlplussystem/systemSQL*Plus: Release 11.1.0.6.0 - Production on 星期四 1月 10 13:49:34 2013Copyright (c) 1...
使用expdp和impdp导出导入远程oracle数据.dmp文件
Crazy__Killer的博客
03-13 3391
创建目录：create directory dpdata as ‘d:\dpdata’; 保证在磁盘中有该目录 给用户赋予制定目录的操作权限(使用sys用户登录): grant read, write on directory dpdata to 用户名称; 查询目录：select * from dba_directories; 创建link，注意要是public：create public ...
用exp/imp把远程数据导入到本地数据库中
竹林晚风
10-22 802
本文转自：http://blog.itpub.net/29485627/viewspace-1788862/ 用exp/imp把远程数据导入到本地数据库中   需求： 把远程10.0.30.xxx主机中的herendh用户下的数据，导入到本机的herendh用户下。   步骤： （1）在cmd窗口中执行导出命令 e
oracle远程expdp导入dmp文件,Oracle DMP备份文件导入(impdp)导出(expdp)方法
weixin_35795512的博客
04-02 435
一 impdp 导入--删除用户若用户已经存在(可以使用Oracle自带的sqlplus进行连接)SQL> drop user USER_NAME cascadeSQL> /SQL> drop tablespace USER_TABLESPACE including contents and datafilesSQL> /--创建表空间下载SQL> CREATE ...
Oracle数据库远程导入(EXP)、导出(IMP)
zyfromcq的专栏
04-25 3198
用exp/imp远程(本地)操作数据库 exp/imp远程(本地)区别，远程操作需在本地客户端创建和服务端对应的服务名 如： 1、在D:\oracle\ora92\network\admin\tnsnames.ora 中配置如下信息： PQPMS = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL =...
数据泵(impdb)导入Oracle数据库
最新发布
ζั͡山 ั͡有扶苏 ั͡✾的博客
10-07 740
注意：在导入数据的时候需要检查源数据的表空间大小，默认表空间最大只有32G，超过容量会导致导入失败。所以超过32G的表空间需要创建大表空间。路径是导出的dmp文件存放的路径必须存在。table_exists_action=replace /存在的表动作(覆盖)/CONTENT=ALL 用于指定导入的内容范围。上面命令只是指定了导出文件存放的路径，但是这个路径需要自己手动创建和赋权。REMAP_SCHEMA=[源用户名1]:[目标用户名2]impdp [用户名]/[密码]@[服务名]
[Oacle] [详细] impdp/expdp 使用详解
qq_39194322的博客
09-17 8182
大部分是转的，各种，记录下。 EXPDP 可以导出所有数据库的数据，只要它能连接到这个数据库，或者它登录的数据库 上能读取到被导出的库的数据，因为此时可以通过数据库链来读取被导出的库的数据。 http://zalbb.itpub.net/post/980/395955 a. 创建到服务端的dblink create database link link_name connect to username identified by password using 'connect_string' ;.
【第006篇】通过impdp命令导入dmp文件到Oracle11g数据库中
嘉&年华的博客
11-14 4955
通过impdp命令导入dmp文件到Oracle11g数据库中
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值