oracle impdp,ORACLE EXPDP和IMPDP示例

最新推荐文章于 2024-03-22 07:00:00 发布
最新推荐文章于 2024-03-22 07:00:00 发布
阅读量142 收藏
点赞数
文章标签： oracle impdp

一、创建DIRECTORY

SQL> create  directory backupdir as '/u01/backupdir/';

Directory created

SQL> select * from dba_directories;

OWNER                          DIRECTORY_NAME                 DIRECTORY_PATH

------------------------------ ------------------------------ --------------------------------------------------------------------------------

SYS                            BACKUPDIR                      /u01/backupdir/

SYS                            SQLDR                          /u01/oracle/sqldr

SYS                            EXPDIR                         /u01/expdir

SYS                            SUBDIR                         /u01/app/oracle/product/11.2.0/dbhome_1/demo/schema/order_entry//2002/Sep

SYS                            SS_OE_XMLDIR                   /u01/app/oracle/product/11.2.0/dbhome_1/demo/schema/order_entry/

SYS                            LOG_FILE_DIR                   /u01/app/oracle/product/11.2.0/dbhome_1/demo/schema/log/

SYS                            DATA_FILE_DIR                  /u01/app/oracle/product/11.2.0/dbhome_1/demo/schema/sales_history/

SYS                            XMLDIR                         /ade/b/1191423112/oracle/rdbms/xml

SYS                            MEDIA_DIR                      /u01/app/oracle/product/11.2.0/dbhome_1/demo/schema/product_media/

SYS                            DATA_PUMP_DIR                  /u01/app/oracle/admin/orcl/dpdump/

SYS                            ORACLE_OCM_CONFIG_DIR          /u01/app/oracle/product/11.2.0/dbhome_1/ccr/state

11 rows selected

二、创建测试表空间和用户

SQL> create tablespace backupdir01 datafile '/u01/app/oracle/oradata/orcl/backup01.dbf' size 500m;

Tablespace created

SQL> create user user01 identified by user01 default tablespace backupdir01 temporary tablespace temp01;

User created

SQL> create tablespace backupdir02 datafile '/u01/app/oracle/oradata/orcl/backup02.dbf' size 500m;

Tablespace created

SQL> create user user02 identified by user02 default tablespace backupdir02 temporary tablespace temp01;

User created

三、授权

SQL> grant read,write on directory backupdir to user01,user02;

Grant succeeded

SQL> grant connect,resource to user01,user02;

Grant succeeded

SQL> conn user01/user01

Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0

Connected as user01@ORACLE_LINUX

SQL> create table user01 (id number,name varchar2(500));

Table created

SQL>

SQL> begin

2  for i in 1..20 loop

3  insert into user01 values(i,'Jerry'||i);

4  end loop;

5  end;

6  /

PL/SQL procedure successfully completed

SQL> commit;

Commit complete

SQL> select * from user01;

ID NAME

---------- --------------------------------------------------------------------------------

1 Jerry1

2 Jerry2

3 Jerry3

4 Jerry4

5 Jerry5

6 Jerry6

7 Jerry7

8 Jerry8

9 Jerry9

10 Jerry10

11 Jerry11

12 Jerry12

13 Jerry13

14 Jerry14

15 Jerry15

16 Jerry16

17 Jerry17

18 Jerry18

19 Jerry19

20 Jerry20

20 rows selected

SQL> conn user02/user02

Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0

Connected as user02@ORACLE_LINUX

SQL> create table user02  (id number,name varchar2(500));

Table created

SQL>

SQL> begin

2  for i in 1..20 loop

3  insert into user02 values(i,'Jerry'||i);

4  end loop;

5  end;

6  /

PL/SQL procedure successfully completed

SQL> commit;

Commit complete

SQL> select * From user02;

ID NAME

---------- --------------------------------------------------------------------------------

1 Jerry1

2 Jerry2

3 Jerry3

4 Jerry4

5 Jerry5

6 Jerry6

7 Jerry7

8 Jerry8

9 Jerry9

10 Jerry10

11 Jerry11

12 Jerry12

13 Jerry13

14 Jerry14

15 Jerry15

16 Jerry16

17 Jerry17

18 Jerry18

19 Jerry19

20 Jerry20

20 rows selected

四、全库导出测试

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

FLASHBACK automatically enabled to preserve database integrity.

Starting "SYS"."SYS_EXPORT_FULL_01":  "/******** AS SYSDBA" directory=backupdir full=y dumpfile=fullexp.dmp logfile=fullexp.log parallel=2

Estimate in progress using BLOCKS method...

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 146.7 MB

. . exported "SH"."CUSTOMERS"                            9.853 MB   55500 rows

. . exported "PM"."ONLINE_MEDIA"                         7.752 MB       9 rows

. . exported "EYGLE"."EYGLE"                             7.037 MB   72829 rows

. . exported "JERRY"."JERRY"                             7.037 MB   72828 rows

. . exported "JERRY"."JERRY_COPY"                        6.153 MB   62829 rows

. . exported "APEX_030200"."WWV_FLOW_PAGE_PLUGS"         3.835 MB    7417 rows

. . exported "APEX_030200"."WWV_FLOW_STEP_ITEMS"         3.505 MB    9673 rows

. . exported "APEX_030200"."WWV_FLOW_DICTIONARY$"        2.909 MB   70601 rows

. . exported "SH"."SUPPLEMENTARY_DEMOGRAPHICS"           697.3 KB    4500 rows

. . exported "JERRY"."PARTITION_DBA_TABLES_COPY":"P7"    1.919 MB  120832 rows

. . exported "JERRY"."PARTITION_DBA_TABLES_COPY":"P8"    2.298 MB  147456 rows

. . exported "OE"."PRODUCT_DESCRIPTIONS"                 2.379 MB    8640 rows

. . exported "APEX_030200"."WWV_FLOW_STEP_PROCESSING"    1.248 MB    2239 rows

. . exported "APEX_030200"."WWV_FLOW_REGION_REPORT_COLUMN"  1.148 MB    7918 rows

. . exported "APEX_030200"."WWV_FLOW_STEP_ITEM_HELP"     1003. KB    6335 rows

Processing object type DATABASE_EXPORT/TABLESPACE

. . exported "SH"."SALES":"SALES_Q4_2001"                2.257 MB   69749 rows

. . exported "SYSMAN"."MGMT_METRICS"                     3.203 MB   12635 rows

. . exported "APEX_030200"."WWV_FLOW_STEPS"              571.0 KB    1755 rows

. . exported "SH"."SALES":"SALES_Q1_1999"                2.071 MB   64186 rows

. . exported "SH"."SALES":"SALES_Q3_2001"                2.130 MB   65769 rows

. . exported "SH"."SALES":"SALES_Q1_2000"                2.012 MB   62197 rows

. . exported "SH"."SALES":"SALES_Q1_2001"                1.965 MB   60608 rows

......................................................................

. . exported "SYSTEM"."SQLPLUS_PRODUCT_PROFILE"              0 KB       0 rows

Master table "SYS"."SYS_EXPORT_FULL_01" successfully loaded/unloaded

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

Dump file set for SYS.SYS_EXPORT_FULL_01 is:

/u01/backupdir/fullexp.dmp

Job "SYS"."SYS_EXPORT_FULL_01" successfully completed at 05:33:03

expdp/impd 会调用 DBMS_DATAPUMP PL/SQL和 DBMS_METADATA  PL/SQL ，一个提供导入导出，一个将metadata(对象定义)存储在 XML 。

五、导出表

[oracle@pc-centos backupdir]$ expdp   \'/  as  sysdba\'  directory=backupdir  dumpfile=table.dmp  logfile=table.log tables=user01.user01;

Export: Release 11.2.0.1.0 - Production on Wed Jan 15 05:44:57 2014

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Starting "SYS"."SYS_EXPORT_TABLE_01":  "/******** AS SYSDBA" directory=backupdir dumpfile=table.dmp logfile=table.log tables=user01.user01

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 "USER01"."USER01"                           5.726 KB      21 rows

Master table "SYS"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded

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

Dump file set for SYS.SYS_EXPORT_TABLE_01 is:

/u01/backupdir/table.dmp

Job "SYS"."SYS_EXPORT_TABLE_01" successfully completed at 05:45:05

六导入表(两种方式)

[oracle@pc-centos backupdir]$ impdp  user01/user01  directory=backupdir  dumpfile=table.dmp  logfile=table.log tables=user01 table_exists_action=replace;

Import: Release 11.2.0.1.0 - Production on Wed Jan 15 05:47:25 2014

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Master table "USER01"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded

Starting "USER01"."SYS_IMPORT_TABLE_01":  user01/******** directory=backupdir dumpfile=table.dmp logfile=table.log tables=user01 table_exists_action=replace

Processing object type TABLE_EXPORT/TABLE/TABLE

Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

. . imported "USER01"."USER01"                           5.726 KB      21 rows

Job "USER01"."SYS_IMPORT_TABLE_01" successfully completed at 05:47:26

[oracle@pc-centos backupdir]$ impdp   \'/  as  sysdba\'   directory=backupdir  dumpfile=table.dmp  logfile=table.log tables=user01.user01 table_exists_action=replace;

Import: Release 11.2.0.1.0 - Production on Wed Jan 15 05:48:52 2014

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Master table "SYS"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded

Starting "SYS"."SYS_IMPORT_TABLE_01":  "/******** AS SYSDBA" directory=backupdir dumpfile=table.dmp logfile=table.log tables=user01.user01 table_exists_action=replace

Processing object type TABLE_EXPORT/TABLE/TABLE

Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

. . imported "USER01"."USER01"                           5.726 KB      21 rows

Job "SYS"."SYS_IMPORT_TABLE_01" successfully completed at 05:48:54

七、导出用户

[oracle@pc-centos backupdir]$ expdp   \'/  as  sysdba\'  directory=backupdir  dumpfile=user.dmp  logfile=user.log schemas=user01,user02;

Export: Release 11.2.0.1.0 - Production on Wed Jan 15 05:51:00 2014

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

FLASHBACK automatically enabled to preserve database integrity.

Starting "SYS"."SYS_EXPORT_SCHEMA_01":  "/******** AS SYSDBA" directory=backupdir dumpfile=user.dmp logfile=user.log schemas=user01,user02

Estimate in progress using BLOCKS method...

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DAT

total estimation using BLOCKS method: 128 KB

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/TABLE/TABLE

. . exported "USER01"."USER01"                           5.726 KB      21 rows

. . exported "USER02"."USER02"                           5.695 KB      20 rows

Master table "SYS"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded

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

Dump file set for SYS.SYS_EXPORT_SCHEMA_01 is:

/u01/backupdir/user.dmp

Job "SYS"."SYS_EXPORT_SCHEMA_01" successfully completed at 05:51:22

八、导入用户

impdp   \'/  as  sysdba\'  directory=backupdir  dumpfile=user.dmp  logfile=user.log schemas=user01,user02 table_exists_action=replace;

九、导出表空间

[oracle@pc-centos backupdir]$ expdp   \'/  as  sysdba\'  directory=backupdir  dumpfile=tbs.dmp  logfile=tbs.log tablespaces=jerry;

Export: Release 11.2.0.1.0 - Production on Wed Jan 15 06:04:41 2014

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Starting "SYS"."SYS_EXPORT_TABLESPACE_01":  "/******** AS SYSDBA" directory=backupdir dumpfile=tbs.dmp logfile=tbs.log tablespaces=jerry

Estimate in progress using BLOCKS method...

Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 18.18 MB

Processing object type TABLE_EXPORT/TABLE/TABLE

Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

. . exported "JERRY"."JERRY"                             7.037 MB   72828 rows

. . exported "JERRY"."JERRY_COPY"                        6.153 MB   62829 rows

. . exported "JERRY"."TEST"                              62.08 KB     835 rows

. . exported "JERRY"."JERRYTEST"                         5.015 KB       1 rows

. . exported "JERRY"."ADDRESS":"P1"                          0 KB       0 rows

. . exported "JERRY"."ADDRESS":"P_444"                       0 KB       0 rows

. . exported "JERRY"."ADDRESS":"P_666"                       0 KB       0 rows

. . exported "JERRY"."ADDRESS":"P_OTHER"                     0 KB       0 rows

. . exported "JERRY"."PARTITION_DBA_TABLES_COPY":"P1"        0 KB       0 rows

. . exported "JERRY"."PARTITION_DBA_TABLES_COPY":"P10"       0 KB       0 rows

. . exported "JERRY"."PARTITION_DBA_TABLES_COPY":"P11"       0 KB       0 rows

. . exported "JERRY"."PARTITION_DBA_TABLES_COPY":"P12"       0 KB       0 rows

. . exported "JERRY"."PARTITION_DBA_TABLES_COPY":"P2"        0 KB       0 rows

. . exported "JERRY"."PARTITION_DBA_TABLES_COPY":"P3"        0 KB       0 rows

. . exported "JERRY"."PARTITION_DBA_TABLES_COPY":"P4"        0 KB       0 rows

. . exported "JERRY"."PARTITION_DBA_TABLES_COPY":"P5"        0 KB       0 rows

. . exported "JERRY"."PARTITION_DBA_TABLES_COPY":"P6"        0 KB       0 rows

. . exported "JERRY"."PARTITION_DBA_TABLES_COPY":"P7"        0 KB       0 rows

. . exported "JERRY"."PARTITION_DBA_TABLES_COPY":"P8"        0 KB       0 rows

. . exported "JERRY"."PARTITION_DBA_TABLES_COPY":"P9"        0 KB       0 rows

. . exported "JERRY"."REDEFIE_TABLE":"P1"                    0 KB       0 rows

. . exported "JERRY"."REDEFIE_TABLE":"P2"                    0 KB       0 rows

. . exported "JERRY"."REDEFIE_TABLE":"P3"                    0 KB       0 rows

. . exported "JERRY"."REDEFIE_TABLE":"P4"                    0 KB       0 rows

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

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

Dump file set for SYS.SYS_EXPORT_TABLESPACE_01 is:

/u01/backupdir/tbs.dmp

Job "SYS"."SYS_EXPORT_TABLESPACE_01" successfully completed at 06:04:47

十、导入表空间

[oracle@pc-centos backupdir]$ impdp  \'/  as  sysdba\'  directory=backupdir  dumpfile=tbs.dmp  logfile=tbs.log tablespaces=jerry table_exists_action=replace;

Import: Release 11.2.0.1.0 - Production on Wed Jan 15 06:06:24 2014

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Master table "SYS"."SYS_IMPORT_TABLESPACE_01" successfully loaded/unloaded

Starting "SYS"."SYS_IMPORT_TABLESPACE_01":  "/******** AS SYSDBA" directory=backupdir dumpfile=tbs.dmp logfile=tbs.log tablespaces=jerry table_exists_action=replace

Processing object type TABLE_EXPORT/TABLE/TABLE

Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

. . imported "JERRY"."JERRY"                             7.037 MB   72828 rows

. . imported "JERRY"."JERRY_COPY"                        6.153 MB   62829 rows

. . imported "JERRY"."TEST"                              62.08 KB     835 rows

. . imported "JERRY"."JERRYTEST"                         5.015 KB       1 rows

. . imported "JERRY"."ADDRESS":"P1"                          0 KB       0 rows

. . imported "JERRY"."ADDRESS":"P_444"                       0 KB       0 rows

. . imported "JERRY"."ADDRESS":"P_666"                       0 KB       0 rows

. . imported "JERRY"."ADDRESS":"P_OTHER"                     0 KB       0 rows

. . imported "JERRY"."PARTITION_DBA_TABLES_COPY":"P1"        0 KB       0 rows

. . imported "JERRY"."PARTITION_DBA_TABLES_COPY":"P10"       0 KB       0 rows

. . imported "JERRY"."PARTITION_DBA_TABLES_COPY":"P11"       0 KB       0 rows

. . imported "JERRY"."PARTITION_DBA_TABLES_COPY":"P12"       0 KB       0 rows

. . imported "JERRY"."PARTITION_DBA_TABLES_COPY":"P2"        0 KB       0 rows

. . imported "JERRY"."PARTITION_DBA_TABLES_COPY":"P3"        0 KB       0 rows

. . imported "JERRY"."PARTITION_DBA_TABLES_COPY":"P4"        0 KB       0 rows

. . imported "JERRY"."PARTITION_DBA_TABLES_COPY":"P5"        0 KB       0 rows

. . imported "JERRY"."PARTITION_DBA_TABLES_COPY":"P6"        0 KB       0 rows

. . imported "JERRY"."PARTITION_DBA_TABLES_COPY":"P7"        0 KB       0 rows

. . imported "JERRY"."PARTITION_DBA_TABLES_COPY":"P8"        0 KB       0 rows

. . imported "JERRY"."PARTITION_DBA_TABLES_COPY":"P9"        0 KB       0 rows

. . imported "JERRY"."REDEFIE_TABLE":"P1"                    0 KB       0 rows

. . imported "JERRY"."REDEFIE_TABLE":"P2"                    0 KB       0 rows

. . imported "JERRY"."REDEFIE_TABLE":"P3"                    0 KB       0 rows

. . imported "JERRY"."REDEFIE_TABLE":"P4"                    0 KB       0 rows

Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

Job "SYS"."SYS_IMPORT_TABLESPACE_01" successfully completed at 06:06:31

十一、REMAP_SCHEMA将原SCHEMA下的对象转移到目标SCHEMA下面

[oracle@pc-centos backupdir]$ expdp   \'/  as  sysdba\'  directory=backupdir  dumpfile=user011.dmp  logfile=user011.log schemas=user01;

Export: Release 11.2.0.1.0 - Production on Wed Jan 15 06:14:25 2014

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

FLASHBACK automatically enabled to preserve database integrity.

Starting "SYS"."SYS_EXPORT_SCHEMA_01":  "/******** AS SYSDBA" directory=backupdir dumpfile=user011.dmp logfile=user011.log schemas=user01

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_EXPORT/ROLE_GRANT

Processing object type SCHEMA_EXPORT/DEFAULT_ROLE

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

Processing object type SCHEMA_EXPORT/TABLE/TABLE

. . exported "USER01"."USER01"                           5.695 KB      20 rows

Master table "SYS"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded

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

Dump file set for SYS.SYS_EXPORT_SCHEMA_01 is:

/u01/backupdir/user011.dmp

Job "SYS"."SYS_EXPORT_SCHEMA_01" successfully completed at 06:14:43

[oracle@pc-centos backupdir]$ impdp   \'/  as  sysdba\'  directory=backupdir  dumpfile=user011.dmp  logfile=user011.log remap_schema=user01:user02 table_exists_action=replace;

Import: Release 11.2.0.1.0 - Production on Wed Jan 15 06:15:30 2014

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

阅读(2466) | 评论(0) | 转发(1) |

裴piapia
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
切换oracle用户impdp,Oracle 12c pdb使用expdp/impdp导入导出
weixin_42650811的博客
04-03 607
12c推出了可插拔数据库，在一个容器cdb中以多租户的形式同时存在多个数据库pdb。在为pdb做数据泵导入导出时和传统的数据库有少许不同。1，需要为pdb添加tansnames2，导入导出时需要在userid参数内指定其tansnames的值，比如 userid=user/pwd@tnsname数据泵导出1、查看当前的SID，查看pdb并切换到容器数据库,这里的pluggable数据库是pdbor...
oracle12c导入,Oracle 12c pdb使用expdp/impdp导入导出
weixin_30975527的博客
04-03 1286
1、查看当前的SID，查看pdb并切换到容器数据库,这里的pluggable数据库是pdborcl[oracle@testadmin]$echo$ORACLE_SID[oracle@testadmin]orcl登录cdb，查看pdb,SQL>showcon_nameCON_NAME------------------------------CDB$ROOTSQL>show...
【Oracle篇】一文搞清expdp/impdp逻辑迁移工具的用法和定时全备实例（第二篇，总共四篇）
最新发布
奈斯DBA的博客
03-22 2309
一文搞清expdp/impdp逻辑迁移工具的用法。expdp/impdp可以以并行导出数据，提高导出效率，并支持对导出的数据进行压缩，节省存储空间。可以通过参数设置选择性地导出指定的数据库对象、指定的数据范围，或者只导出数据库结构而不包括数据。
数据库oracle开发手记——expdp/impdp 详细参数解释
u_nightroad的博客
05-10 6115
数据泵导出实用程序提供了一种用于在Oracle数据库之间传输 数据对象的机制。该实用程序可以使用以下命令进行调用: 示例: expdp scott/tiger DIRECTORY=dmpdir DUMPFILE=scott.dmp 您可以控制导出的运行方式。具体方法是: 在 'expdp' 命令后输入 各种参数。要指定各参数, 请使用关键字: 格式:expdp KEY...
重庆思庄oracle技术分享-impdp测试
duanweifang的博客
04-14 321
impdp默认导入expdp的dmp文件时，通常需要建立相同名称的表空间，而且相同名称的用户名会自动创建. 不过有时可以用impdp参数remap_schema和remap_tablespace来转换用户和表空间. 测试如下： 假设有一个hr19c.dmp文件，原来用户为hr,存储空间为example，example_temp; 现在需要更改用户名及存储表空间导入到新库中： 1、建立新表空间及临时表空间 –表空间 create tablespace newtablespace logging datafi
Oracle数据库通过数据泵expdp、impdp方式备份还原
青春_奋斗不息
02-22 6278
Oracle数据库通过数据泵expdp、impdp方式备份还原数据
Oracle 数据泵expdp、impdp 导入导出 保姆及别
weixin_41790661的博客
05-05 2141
Oracle 数据泵导入导出 expdp impdp 你想要的都在这里 保姆及别
Centos7.6下oracle impdp导入和expdp导出.docx
12-11
本文档将详细介绍如何在 Centos7.6 操作系统环境下利用 Oracle 的数据泵功能（Data Pump）来进行数据的导出（expdp）和导入（impdp）。数据泵是 Oracle 提供的一种高效的数据迁移工具，它能够帮助用户快速地将数据库...
Oracle如何查看impdp正在执行的内容
09-09
在Oracle数据库环境中，数据泵（Data Pump）是用于导入（impdp）和导出（expdp）大量数据的高效工具。然而，在数据导入过程中，有时可能会遇到进程卡住的情况，这时了解如何查看impdp正在执行的内容就显得尤为重要。...
impdp导入表结构和表数据_Oracle使用数据泵 (expdp/impdp)实施迁移
weixin_29266007的博客
02-01 2118
实验环境：1、导出环境：RedHat6.4+Oracle 11.2.0.4.0，利用数据库自带的scott示例用户进行试验测试。Directory：wjqà/tmp/seiang_wjq2、导入环境：CentOS7.1+Oracle 12.2.0.1.0 Oracle12c默认没有scott用户Directory：imp_wjqà/tmp/imp_comsys一、导出数据：特别注意：如果后续要...
Oracle expdp/impdp 使用示例
热门推荐
David Dai -- Focus on Oracle
03-18 5万+
<br /> <br /> <br />在之前的blog：<br />       Oracle 10g Data Pump Expdp/Impdp 详解<br />       http://blog.csdn.net/tianlesoftware/archive/2009/10/15/4674224.aspx<br /> <br />       exp/imp 与 expdp/impdp 对比及使用中的一些优化事项<br />       http://blog.csdn.net/tianlesoft
oracle12c下简单使用expdp&impdp
jc_benben的专栏
11-26 6258
在12c下一切变得不是很熟悉了，毕竟相对之前还是有的 创建授权用户等操作 SQL> show user; USER is "SYS" SQL> show con_name CON_NAME ------------------------------ CDB$ROOT SQL> create user c##dp_u1 identified by oracle; User created
impdp 和expdp参数说明
wll的专栏
12-21 1154
http://blog.sina.com.cn/s/blog_71646b5401010sqg.html EXPDP参数 参数名称 默认值 设置格式 说明 ATTACH ATTCH= [schema_name.]job_name 设置客户会话与已存在的作业之间的联系
如何监控Expdp/Impdp会话进度
Maker
09-08 4791
有时候由于expdp导出的数据量太大，而会话不小心关闭了，如何查看expdp进度如何？通过下面两个视图可以查看到关于expdp工作的进度和相关信息： 1、查看正在运行的job： SELECT * FROM DBA_DATAPUBMP_JOBS; SELECT * FROM DBA_DATAPUMP_SESSIONS; SELECT SID,SERIAL# FROM V$SESSION S,
Oracle 11g R2 数据泵技术详解（expdp impdp）
刘耀龙的博客
06-08 2万+
使用数据泵技术实现逻辑备份逻辑备份概述逻辑备份时创建数据库对象的逻辑副本，并存入一个二进制转储文件的过程。从本质上来讲逻辑备份与恢复实际就是对数据库事实数据的导入和导出。导出：导出就是数据库的逻辑备份，实质是读取一个数据库记录并将这个记录集写入一个文件（扩展名通常是dmp），这些记录的导出与物理位置无关导入：导入即数据库的逻辑恢复，实质是读取被导出的二进制转储文件并将其恢复到数据库。使用数据泵技术...
Oracle使用imp和impdp导入数据
猪猪神功屁
01-02 6382
使用imp导入数据 imp user/root@127.0.0.1/pdborcl file=e:\xxx.dmp log=e:\xxx.log full=y 使用impdp导入数据 - 首先sys登陆 sqlplus sys/root@127.0.0.1/pdborcl as sysdba - 创建对应表空间 create tablespace YUAN datafile '...
Oracle的expdp导出、impdp导出命令
MssGuo的博客
08-02 5477
前言 环境：Centos7.9 Oracle11.2.4.0 我们建议使用expdp导出数据、impdp导入数据，因为impdp能指定导入的表空间，这对数据库规范性来说是件好事，而老的imp命令不能指定表空间。 Oracle使用expdp导出数据 说明：为了规范，我们创建一个目录用来存放导出的dmp文件 --首先，查看当前登录的用户所使用的表空间并记住它 select table_name 表名 ,tablespace_name 所使用表空间 from user_tables; （记住表空间名字）
ORACLE数据泵导入导出案例(expdp & impdp)
connectedtoyou的博客
07-06 6237
ORACLE数据泵导入导出案例(expdp & impdp) 概要： 因项目需要，通常需要将生产库下的部分数据抽取并恢复到测试库上 本文主要介绍数据泵导入导出的几种情况以及错误处理
oracle 终止导出数据,oracle数据库expdp/impdp操作的终止
weixin_42469649的博客
04-07 1832
执行expdp/impdp操作时，如果中途发现执行错误或者其他原因需要取消时，不能直接通过ctrl+c或者关闭操作窗口进行取消。使用以上操作取消后，expdp/impdp进程仍然在运行中。[oracle@rac1 ~]$ expdp userid=\'/ as sysdba\' dumpfile=full.dmp logfile=full.log directory=dump_dir full=y...
expdp / as sysdba
cuiyan1982的专栏
03-21 8521
原文地址：http://jotey.blog.163.com/blog/static/14926370201262315327525/Export as SYS or not?but this mean that I can't use expdp to exporting from 10.1 to 10.2 using SYS?It seems so, it generates ORA-3913...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值