Oracle 10g 數(shù)據(jù)泵分區(qū)表的導(dǎo)出

Oracle 10g中數(shù)據(jù)泵支持本地導(dǎo)出/導(dǎo)入分區(qū)表的分區(qū)，但是NET_LINK不支持分區(qū)表的分區(qū)。以下為導(dǎo)出部分實(shí)驗(yàn)，導(dǎo)入與導(dǎo)出相識。

本地導(dǎo)出：

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, 2007, 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/TABLE
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/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方式導(dǎo)出：

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.

很明顯10g并不支持通過網(wǎng)絡(luò)方式的分區(qū)選擇功能。而且對于分區(qū)表而言，無論是導(dǎo)出還是導(dǎo)入，都是已一個(gè)整體完成的。

服務(wù)器租用/服務(wù)器托管中國五強(qiáng)！虛擬主機(jī)域名注冊頂級提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]