为什么 expdp 看不到此表？它在那里？

Question

• 有人知道为什么会发生这种事吗？我可以选择桌子，但是无法导出。

  C:>sqlplus myschema/myschema
  SQL*Plus: Release 12.1.0.2.0 Production on Mon Aug 1 14:43:45 2016
  Copyright (c) 1982, 2014, Oracle.  All rights reserved.
  Last Successful login time: Mon Aug 01 2016 14:42:51 -04:00
  Connected to:
  Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
  With the Partitioning, OLAP, Advanced Analytics, and Real Application Testing opt
  ions
  SQL> select * from product;
          ID NAME
  ---------- --------------------
           1 sample_product_name
  SQL> exit
  Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64
  bit Production
  With the Partitioning, OLAP, Advanced Analytics, and Real Application Testing opt
  ions
  C:>expdp myschema/myschema@oradev tables=product directory=DATA_PUMP_DIR dumpfi
  le=expdp_myschema.dmp logfile=expdp_myschema.log
  Export: Release 12.1.0.2.0 - Production on Mon Aug 1 14:44:16 2016
  Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.
  Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit
  Production
  With the Partitioning, OLAP, Advanced Analytics, and Real Application Testing opt
  ions
  WARNING: Oracle Data Pump operations are not typically needed when connected to
  the root or seed of a container database.
  Starting "MYSCHEMA"."SYS_EXPORT_TABLE_01":  myschema/********@oradev tables=prod
  uct directory=DATA_PUMP_DIR dumpfile=expdp_myschema.dmp logfile=expdp_myschema.l
  og
  Estimate in progress using BLOCKS method...
  Total estimation using BLOCKS method: 0 KB
  Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
  **ORA-39166: Object MYSCHEMA.PRODUCT was not found** or could not be exported or imp
  orted.
  ORA-31655: no data or metadata objects selected for job
  Job "MYSCHEMA"."SYS_EXPORT_TABLE_01" completed with 2 error(s) at Mon Aug 1 14:4
  4:18 2016 elapsed 0 00:00:01
  

Answer 1

在expdp命令行的末尾添加参数CONTENT=ALL，如下所示：

expdp-myschema/myschema@oradevtables=产品目录=DATA_PUMP_DIR dumpfi le=expdp_myschema.dmp logfile=expdp_myschema.log CONTENT=ALL

并执行它。