impdp详解（详解impdp）.doc

impdp详解(详解impdp)
EXPDP and IMPDP usage instructions EXPDP and IMPDP instructions
Oracle Database 10g introduces the latest data pump (Data Dump) technology, so that DBA or developers can move database metadata (object definition) and data quickly to another Oracle Database
The role of data pump export import (EXPDP and IMPDP)
1, to achieve logical backup and logical recovery
2, moving objects between database users
3, moving objects between databases
4, to achieve tablespace migration
The difference between data pump export import and traditional export import
Before 10g, the export and import of traditional respectively using EXP tools and IMP tools, starting from 10g, not only retains the original EXP and IMP tools are also provided and should pay attention to the data pump import and export tools EXPDP and IMPDP. using EXPDP and IMPDP;
EXP and IMP are client segment tools, which can be used either in segments or in service segments
EXPDP and IMPDP are server side tool programs. They can only
be used on the ORACLE server side and cannot be used on the client side
IMP is only suitable for EXP export files, not suitable for EXPDP export files; IMPDP is only suitable for EXPDP export files, and is not suitable for EXP export files
Data pump export includes export table, export scheme, export table space, export database 4 ways
mand line options
1. ATTACH
This option is used to establish an association between the client session and the existing export function
ATTACH=[schema_name.]job_name
Schema_name is used to specify the program name, and job_name is used to specify the export job name. Note that if you use the ATTACH option, you cannot specify any other options except the connection string and the ATTACH option on mand line. The example is as follows:
Expdp scott/tiger ATTACH=
2. CONTENT
This option specifies the content to export. The default value is ALL
CONTENT={ALL DATA_ONLY METADATA_ONLY} | |
When CONTENT is set to AL