Export of Oracle 10g Data Pump Partition Table
In Oracle 10 Gb, Data Pump supports local export/import of Partition Table partitions, but NET_LINK does not support partition tables. The following are some export experiments.
Local export:
C: \ Users \ xionglang> expdp test/test dumpfile = test. dmp logfile = test. log directory = dir_dump tables = t: p1
Export: Release 10.2.0.4.0-64bit Production on Tuesday, 19 June, 2012 22:57:09
Copyright (c) 2003,200 7, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0-64bit
Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "TEST". "SYS_EXPORT_TABLE_01": test/******** dumpfile = test. dmp logfile =
Test. log directory = dir_dump tables = t: p1
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 2 MB
Processing object type TABLE_EXPORT/TABLE
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
.. Exported "TEST". "T": "P1" 824.7 KB 49989 rows
Master table "TEST". "SYS_EXPORT_TABLE_01" successfully loaded/unloaded
**************************************** **************************************
Dump file set for TEST. SYS_EXPORT_TABLE_01 is:
D: \ TEST. DMP
Job "TEST". "SYS_EXPORT_TABLE_01" successfully completed at 22:57:17
NET_LINK export:
C: \ Users \ xionglang> expdp test/test dumpfile = test1.dmp logfile = test. log directory = dir_dump tables = t: p2 network = test
ORA-39001: invalid argument value
ORA-39203: Partition selection is not supported over a network link.
Obviously, 10 Gb does not support partition selection through the network. In addition, for partition tables, both export and import operations have been completed.