设为首页 加入收藏

TOP

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

#按照表导出

[oracle@host2 ~]$ expdp u1/tiger tables=family  dumpfile='u1_family.dump' directory=dump_dir job_name=family1

Export: Release 10.2.0.5.0 - 64bit Production on Monday, 11 August, 2014 12:58:39

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

Starting "U1"."FAMILY1":  u1/******** tables=family dumpfile=u1_family.dump directory=dump_dir job_name=family1

Estimate in progress using BLOCKS method...

Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 64 KB

Processing object type TABLE_EXPORT/TABLE/TABLE

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

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

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

Dump file set for U1.FAMILY1 is:

  /oracle/product/10.2.0.5/rdbms/log/u1_family.dump

Job "U1"."FAMILY1" successfully completed at 12:58:44

#跨用户导入:

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

Import: Release 10.2.0.5.0 - 64bit Production on Monday, 11 August, 2014 13:23:26

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_family_1.dump directory=dump_dir REMAP_SCHEMA=u1:u2

Processing object type TABLE_EXPORT/TABLE/TABLE

Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

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

Job "U2"."SYS_IMPORT_FULL_01" successfully completed at 13:23:30

#修改路径

create or replace directory dump_dir as '/oracle/backup';

grant read,write on directory dump_dir to u2;

#按照用户导出

[oracle@host2 ~]$ expdp u1/tiger schemas=u1  dumpfile='u1.dump' directory=dump_dir

Export: Release 10.2.0.5.0 - 64bit Production on Monday, 11 August, 2014 13:25:40

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

Starting "U1"."SYS_EXPORT_SCHEMA_01":  u1/******** schemas=u1 dumpfile=u1.dump directory=dump_dir

Estimate in progress using BLOCKS method...

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 64 KB

Processing object type SCHEMA_EXPORT/USER

Processing object type SCHEMA_EXPORT/SYSTEM_GRANT

Processing object type SCHEMA_EXPO

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

最新文章

热门文章

Hot 文章

Python

C 语言

C++基础

大数据基础

linux编程基础

C/C++面试题目