Brief introduction of new characteristics of Oracle 11g R2 data Pump (二) Improvement of data pump's export method to table

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 describes the data pump on the table to improve the way to export.

In 11gr1 and previous releases, there was a limit to the export of table schemas, all exported tables must be in the same schema, which made it inconvenient to back up individual tables under different schemas:

bash-3.00$ EXPDP yangtk/yangtk directory=d_output DUMPFILE=T.DP tables=yangtk.t

Export:release11.1.0.6.0-64bit Production on Tuesday, 08 September, 2009 0:40:36

Copyright (c) 2003, 2007, Oracle. All rights reserved.

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

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

^CUDE-00001: The user has requested to cancel the current operation

bash-3.00$ EXPDP yangtk/yangtk directory=d_output dumpfile=t.dp tables=yangtk.t, test.t

Export:release11.1.0.6.0-64bit Production on Tuesday, 08 September, 2009 0:41:01

Copyright (c) 2003, 2007, Oracle. All rights reserved.

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

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

UDE-00012: Table schema export applies only to objects in one scenario

In 11.2, this limit has been removed, so as long as you have permission, you can export the table objects under any user:

[Oracle@bjtest ~]$ expdp yangtk/yangtk directory=d_output dumpfile=t_two_onwer.dp tables=yangtk.t test.t

Export:release11.2.0.1.0-production on Tuesday September 8 00:21:22 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

Start "YANGTK". Sys_export_table_01 ": yangtk/******** directory=d_output dumpfile=t_two_onwer.dp tables=yangtk.t test.t

Using the blocks method to estimate ...

Working with Object Types Table_export/table/table_data

Total estimate using the Blocks method: 8.125 MB

Working with Object Types table_export/table/table

. . "YANGTK" was exported. T "5.766 MB 143936 Lines

. . "TEST" was exported. T "5 KB 1 lines

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

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

Yangtk. The set of dump files for sys_export_table_01 is:

/home/oracle/t_two_onwer.dp

The job "YANGTK". Sys_export_table_01 "completed successfully at 00:21:31

While this is a small improvement, it does make it much easier to export the data pump's table schema.

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