expdp 带content选项data_only导出时报ORA-39126,不带是正常

mastermouse

带content选项导出错误
Export: Release 11.2.0.3.0 - Production on Mon Sep 16 10:15:41 2013

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Data Mining, Oracle Database Vault and Real Application Testing optio
Starting "BPPF_BIS"."SYS_EXPORT_TABLE_02":  bppf_bis/******** tables=T_BAP_FAVORITE content=data_only ESTIMATE_ONLY=y directory=MOUSE_DMPDIR
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PROCESS_TABLE_EXISTS_ACTION [TABLE_DATA:"BPPF_BIS"."T_BAP_FAVORITE"]
ORA-31600: invalid input value  for parameter TABLE_EXISTS_ACTION in function KUPW$WORKER.PROCESS_TABLE_EXISTS_ACTION

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 9001

----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0x9f693e6e0     20462  package body SYS.KUPW$WORKER
0x9f693e6e0      9028  package body SYS.KUPW$WORKER
0x9f693e6e0     16105  package body SYS.KUPW$WORKER
0x9f693e6e0     12466  package body SYS.KUPW$WORKER
0x9f693e6e0      8300  package body SYS.KUPW$WORKER
0x9f693e6e0     10784  package body SYS.KUPW$WORKER
0x9f693e6e0     13698  package body SYS.KUPW$WORKER
0x9f693e6e0      4633  package body SYS.KUPW$WORKER
0x9f693e6e0      9753  package body SYS.KUPW$WORKER
0x9f693e6e0      1775  package body SYS.KUPW$WORKER
0x9f60b4458         2  anonymous block

Job "BPPF_BIS"."SYS_EXPORT_TABLE_02" stopped due to fatal error at 10:15:44

正常导出－－没问题
[oracle@bppfedb1 mouse]$ expdp bppf_bis/xxxx tables=T_BAP_FAVORITE  ESTIMATE_ONLY=y directory=MOUSE_DMPDIR;

Export: Release 11.2.0.3.0 - Production on Mon Sep 16 10:00:31 2013

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Data Mining, Oracle Database Vault and Real Application Testing optio
Starting "BPPF_BIS"."SYS_EXPORT_TABLE_02":  bppf_bis/******** tables=T_BAP_FAVORITE ESTIMATE_ONLY=y directory=MOUSE_DMPDIR
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
.  estimated "BPPF_BIS"."T_BAP_FAVORITE"                   128 KB
Total estimation using BLOCKS method: 128 KB
Job "BPPF_BIS"."SYS_EXPORT_TABLE_02" successfully completed at 10:00:34

查询这个表的类型
SQL> select segment_name,segment_type from user_segments where segment_name='T_BAP_FAVORITE';

SEGMENT_NAME                                                                      SEGMENT_TYPE
--------------------------------------------------------------------------------- ------------------
T_BAP_FAVORITE                                                                    TABLE


也不是同义词
set linesize 1000
col owner format a25;
col synonym_name format a25;
col table_owner format a25;
col table_name format a25;
col db_link format a25;
SQL> select synonym_name, table_owner, table_name, db_link from user_synonyms where synonym_name='T_BAP_FAVORITE' ;

no rows selected

各位指导下

mastermouse

https://support.oracle.com/epmos/faces/ui/km/SearchDocDisplay.jspx?returnToSrId=&srnum=&_afrLoop=180313444717803&type=DOCUMENT&id=1508068.1&displayIndex=1&_afrWindowMode=0&_adf.ctrl-state=22lg4ldsi_82

MOS上有解释，应该是 "The ESTIMATE_ONLY parameter cannot be used in conjunction with both the CONTENT=DATA_ONLY and METADATA_ONLY parameter. "