Oracle10G Data Pump learning minutes (expdp/impdp)

Welcome to the Oracle community forum, and interact with 2 million technical staff to enter the instance: 1. Using DBLINK: The tablespace is not the same: table_space12, table_space21: table_space222, and Tong

Welcome to the Oracle community forum and interact with 2 million technical staff> enter the instance: 1. Use DBLINK: The tablespace is different. impdp logfile = DUP_MCMDB.LOG network_link = to_crm_7 schemas = MCMDB REMAP_TABLESPACE = table_space11: table_space12, table_space21: table_space22 2. Pass

Welcome to the Oracle community forum and interact with 2 million technical staff> enter

Instance:

1. DBLINK: The tablespace is different.

Impdp logfile = DUP_MCMDB.LOG network_link = to_crm_7 schemas = MCMDB REMAP_TABLESPACE = table_space11: table_space12, table_space21: table_space22

2. DBLINK: the solution (schemas) is different.

Impdp logfile = DUP_MCMDB.LOG network_link = to_crm_7 schemas = MCMDB remap_schema = MCMDB: MCMDB1

Preface:

Oracle Database 10 Gb introduces the latest Data pump technology, allowing DBAs or developers to quickly move Database metadata (object definition) and Data to another oracle Database.

Role of Data Pump Export Import (EXPDP and IMPDP)

1. implement logical backup and logical recovery.

2. move objects between database users.

3. move objects between databases

4. Table space migration.

Differences between data pump export and traditional export: before 10 Gb, the traditional export and import respectively use the EXP tool and IMP tool, starting from 10 Gb, the original EXP and IMP tools are retained, and the data pump export and import tools EXPDP and IMPDP are also provided. note when using EXPDP and IMPDP. EXP and IMP are client-segment tool programs that can be used either on the client or on the server.

EXPDP and IMPDP are tool programs on the server. They can only be used on the ORACLE server. IMP is not applicable only to EXP export files, but not EXPDP export files. IMPDP is applicable only to EXPDP export files, it does not apply to export EXP files.

Data Pump export includes four modes: export table, export scheme, export tablespace, and export database.

Create directory and assign permissions:

SQL> create directory dump_dir as '/u01/dmdir ';

SQL> grant read, write on directory to test;

SQL> select * from dba_directories;-view the Directory

[1] [2] [3] [4] [5] [6]