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.