设为首页 加入收藏

TOP

ORACLE数据库中impd expd的几个使用范例(四)
2018-01-13 06:07:03 】 浏览:427
Tags:ORACLE 数据库 impd expd 使用 范例
EX/INDEX

Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Processing object type TABLE_EXPORT/TABLE/COMMENT

. . exported "U1"."FAMILY"                               5.984 KB       2 rows

Master table "U1"."SYS_EXPORT_TABLESPACE_01" successfully loaded/unloaded

******************************************************************************

Dump file set for U1.SYS_EXPORT_TABLESPACE_01 is:

  /oracle/backup/u1_u1.dump

Job "U1"."SYS_EXPORT_TABLESPACE_01" successfully completed at 13:29:34

#通过表空间导入(remap_tablespace remap_user)

[oracle@host2 ~]$ impdp u2/tiger  dumpfile=u1_u1.dump directory=dump_dir  REMAP_TABLESPACE=u1:u3 REMAP_SCHEMA=u1:u3

[oracle@host2 ~]$ impdp u2/tiger  dumpfile=u1_u1.dump directory=dump_dir  REMAP_TABLESPACE=u1:u3 REMAP_SCHEMA=u1:u3

Import: Release 10.2.0.5.0 - 64bit Production on Monday, 11 August, 2014 13:39:35

Copyright (c) 2003, 2007, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

With the Partitioning, Real Application Clusters, OLAP, Data Mining

and Real Application Testing options

Master table "U2"."SYS_IMPORT_FULL_01" successfully loaded/unloaded

Starting "U2"."SYS_IMPORT_FULL_01":  u2/******** dumpfile=u1_u1.dump directory=dump_dir REMAP_TABLESPACE=u1:u3 REMAP_SCHEMA=u1:u3

Processing object type TABLE_EXPORT/TABLE/TABLE

Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

. . imported "U3"."FAMILY"                               5.984 KB       2 rows

Job "U2"."SYS_IMPORT_FULL_01" successfully completed at 13:39:37

#导入导出,要新建相应的表空间和用户shemas

#表的追加

[oracle@host2 ~]$ impdp u2/tiger  dumpfile=u1_u1.dump directory=dump_dir  REMAP_TABLESPACE=u1:u3 REMAP_SCHEMA=u1:u3 table_exists_action=append

#表的替换

[oracle@host2 ~]$ impdp u2/tiger  dumpfile=u1_u1.dump directory=dump_dir  REMAP_TABLESPACE=u1:u3 REMAP_SCHEMA=u1:u3 table_exists_action=replace;

Import: Release 10.2.0.5.0 - 64bit Production on Monday, 11 August, 2014 13:44:18

Copyright (c) 2003, 2007, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

With the Partitioning, Real Application Clusters, OLAP, Data Mining

and Real Application Testing options

Master table "U2"."SYS_IMPORT_FULL_01" successfully loaded/unloaded

Starting "U2"."SYS_IMPORT_FULL_01":  u2/******** dumpfile=u1_u1.dump directory=dump_dir REMAP_TABLESPACE=u1:u3 REMAP_SCHEMA=u1:u3 table_exists_action=replace

Processing object type TABLE_EXPORT/TABLE/TABLE

Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

. . imported "U3"."FAMILY"                               5.984 KB       2 rows

Job "U2"."

首页 上一页 1 2 3 4 下一页 尾页 4/4/4
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
上一篇oracle数据库中的(+)是什么意思? 下一篇oracle sqluldr2工具使用方法介绍

最新文章

热门文章

Hot 文章

Python

C 语言

C++基础

大数据基础

linux编程基础

C/C++面试题目