Introduction to the new characteristics of Oracle 11g R2 data Pump (i) legacy mode of data pump

Source: Internet
Author: User
Tags create directory reserved

Oracle's 11GR2 version does not make much of a change to the data pump, mainly by adding support for the original version parameters and removing some small restrictions.

This article introduces the legacy mode of the data pump.

The function introduced in 11.2 is mainly the Exp/imp tool to gradually launch the history stage. Although data pump import and export is better than traditional export import tool exp/imp, whether from function or performance, it can be troublesome to migrate all the way to EXPDP if the user contains a lot of script call exp.

The legacy mode of the database is to be able to migrate the traditional export and import methods smoothly to the data pump mode.

[Oracle@bjtest ~]$ EXPDP yangtk/yangtk file=t.dmp

Export:release11.2.0.1.0-production on Sunday September 6 22:32:43 2009

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

Connect to: Oracle database11genterprise Edition release11.2.0.1.0-64bit Production

With the partitioning, OLAP, Data Mining and real application testing options

The old schema is active because of the following parameters:

Old mode parameter: "file=t.dmp" position: Command line, replaced by: "Dumpfile=t.dmp"

The old mode has the Reuse_dumpfiles=true parameter set.

The old mode has the Nologfile=true parameter set.

Start "YANGTK". Sys_export_schema_01 ": yangtk/******** dumpfile=t.dmp reuse_dumpfiles=true nologfile=true

Using the blocks method to estimate ...

Working with Object Types Schema_export/table/table_data

Total estimate using the Blocks method: 4 MB

Working with Object Types Schema_export/user

Working with Object Types Schema_export/system_grant

Working with Object Types Schema_export/role_grant

Working with Object Types Schema_export/default_role

Working with Object Types Schema_export/pre_schema/procact_schema

Working with Object Types schema_export/table/table

Working with Object Types Schema_export/table/index/index

Working with Object Types Schema_export/table/constraint/constraint

Working with Object Types Schema_export/table/index/statistics/index_statistics

Working with Object Types Schema_export/table/comment

. . "YANGTK" was exported. T "2.886 MB 71968 Lines

The primary table "YANGTK" was successfully loaded/unloaded. Sys_export_schema_01 "

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

Yangtk. The set of dump files for sys_export_schema_01 is:

/data/oracle/admin/test112/dpdump/t.dmp

The job "YANGTK". Sys_export_schema_01 "completed successfully at 22:33:25

This article URL address: http://www.bianceng.cn/database/Oracle/201410/45398.htm

As you can see, file is an exp parameter, and because the EXP--parameter is specified, EXPDP automatically becomes the legacy mode, in order to maintain the exact same export effect as the Exp tool, EXPDP uses DumpFile to specify the file name and specifies Reuse_ Dumpfiles parameters and Nologfile parameters.

It should be explained that although EXPDP supports exp parameters, the export is still done in EXPDP mode, and the exported files are stored on the database server. Also, EXPDP cannot export an exp-formatted file, IMPDP cannot use a file exported by exp, and the same EXPDP legacy exported file cannot be used by IMP.

Also note that the directory parameter is not currently used, but this parameter is still necessary, otherwise it is necessary to use the default value Data_pump_dir, if the user does not have DATA_PUMP_DIR access rights, will be an error. Of course, but you don't want to specify directory by parameter, you can also set the value of the environment variable DATA_PUMP_DIR.

The parameters of various data pumps are also supported in the legacy mode of export. For some meaningless traditional parameters, such as buffer, will be automatically ignored by the data pump.

Finally, look at a more complicated example:

Sql> Conn YANGTK/YANGTK

is connected.

Sql> Create directory D_output as '/home/oracle ';

The directory has been created.

Sql> exit

From Oracle database11genterprise Edition release11.2.0.1.0-64bit Production

With the partitioning, OLAP, Data Mining and real application testing options Disconnect

[Oracle@bjtest ~]$ Export Data_pump_dir=d_output

[Oracle@bjtest ~]$ expdp yangtk/yangtk file=t.dp tables=t buffer=20480000 compress=n grants=n

Export:release11.2.0.1.0-production on Monday September 7 00:05:31 2009

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

Connect to: Oracle database11genterprise Edition release11.2.0.1.0-64bit Production

With the partitioning, OLAP, Data Mining and real application testing options

The old schema is active because of the following parameters:

Ignore old mode parameters: "buffer=20480000" Location: Command line.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.