impdp详解（详解impdp）.doc

impdp详解（详解impdp） EXPDP and IMPDP use the EXPDP and IMPDP instructions Oracle Database 10g introduced the latest data pump (Data Dump) technology, DBA or developers can use database metadata (object definition) and fast moving data to another Oracle database. The data pump import and export (EXPDP and IMPDP) role 1, realize the logical backup and recovery logic. In 2, mobile database objects between users. 3, the moving objects in the database 4, the table space move. The difference between the data pump import and export and import and export of the traditional 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 tools program, they can be used in the section, can also be used in the service period. EXPDP and IMPDP are server tools, they can only be used in the ORACLE server, not the client to use IMP is only applicable to EXP export documents, does not apply to EXPDP export file; IMPDP is only applicable to EXPDP export documents, and does not apply to EXP export file. Data pump export including export, export, export table, export data in 4 ways. EXPDP command line option 1. ATTACH This option is used in client session and the existing relationship between syntax derived role. ATTACH=[schema_name.]job_name Schema_name is used to specify the program name, job_name is used to specify the export operations. Note that if you use the ATTACH option on the command line, in addition to the connection string and the ATTACH option, any other option is not specified, the following example: Expdp scott/tiger ATTACH=scott.export_job 2. CONTENT This option is used to specify the content to be exported. The default value is ALL CONTENT={ALL DATA_ONLY METADATA_ONLY} | | When CONTENT is set to ALL, the derived object definition and