不完整的sysaux expdp卸载(ORACLE)

Question

我的问题非常简单，不需要任何特定的文档。当我使用OracleDatabase11g发行版11.2.0.4.0-64位运行这样的expdp命令时：

expdp system/******* directory=DATA_PUMP_DIR dumpfile=SYSAUX.dmp logfile=sysaux.log TABLESPACES=SYSAUX

我看到没有关于系统模式的表。我确信系统模式中的表属于SYSAUX表空间，比如DBA_SEGMENTS和DBA_EXTENTS告诉我，但是我没有看到任何这样的日志行：

.. exported "SYSTEM"."TABLENAME"                       120.2 GB 8396874 rows

expdp没有错误信息，只是缺少表.有人能给我一些建议吗？

Answer 1

取决于您试图导出哪些表。内建表不导出。导出用户创建的表。

SQL> create table system.t1 tablespace sysaux as select * from dba_objects;

Table created.

SQL> select count(*) from dba_segments where tablespace_name = 'SYSAUX';

  COUNT(*)
----------
      2457

SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
[oracle@o61 ~]$ expdp \'/ as sysdba\' tablespaces=sysaux

Export: Release 11.2.0.4.0 - Production on Thu Jun 15 20:55:08 2017

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
Starting "SYS"."SYS_EXPORT_TABLESPACE_01":  "/******** AS SYSDBA" tablespaces=sysaux
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
. . exported "SYSTEM"."T1"                               1.420 MB   15715 rows
Master table "SYS"."SYS_EXPORT_TABLESPACE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_TABLESPACE_01 is:
  /opt/oracle/base/product/db11204ee/rdbms/log/expdat.dmp
Job "SYS"."SYS_EXPORT_TABLESPACE_01" successfully completed at Thu Jun 15 20:55:23 2017 elapsed 0 00:00:08