当前位置:首页 > 开发 > 数据库 > 正文

In this Document Symptoms Cause Solution References --------------------

发表于: 2014-10-23   作者:czmmiao   来源:转载   浏览次数:
摘要: In this Document  Symptoms  Cause  Solution  References   -------------------------------------------------------------------------------- Applies to: Oracle Server -

In this Document
 Symptoms
 Cause
 Solution
 References

 

--------------------------------------------------------------------------------


Applies to:
Oracle Server - Enterprise Edition - Version 10.2.0.3 and later
Information in this document applies to any platform.
***Checked for relevance on 23-NOV-2012***
Symptoms
DataPump export of table SYS.AUD$ fails with errors:

ORA-39165: Schema SYS was not found.
ORA-39166: Object AUD$ was not found.
ORA-31655: no data or metadata objects selected for job
Job "SYS"."SYS_EXPORT_TABLE_01" completed with 3 error(s) at 13:49:47
Cause
There is a restriction on dataPump export. It cannot export schemas like SYS, ORDSYS, EXFSYS, MDSYS, DMSYS, CTXSYS, ORDPLUGINS, LBACSYS, XDB, SI_INFORMTN_SCHEMA, DIP, DBSNMP and WMSYS in any mode. The Utilities Guide indicates the restriction only on full export mode, but the restriction actually applies to all modes.

Solution
Export the table SYS.AUD$ using the traditional export:

#> exp system/<password> file=dumpfile.dmp log=logfile.log tables=sys.aud$
Other options are:

- use CTAS (Create Table As Select) to copy the SYS.AUD$ data into a non-restricted schema.

- use the DBMS_AUDIT_MGMT package of Audit Vault to manage and purge audit data (see Note 731908.1). This allows for the facility to move the AUD$ table out of the SYSTEM tablespace, which can negate the need to export the table.

NOTE: This issue also applies to other SYS owned auditing tables such as FGA_LOG$

References
BUG:5647223 - DATAPUMP EXPORT FAILS ORA-31655
NOTE:731908.1 - New Feature DBMS_AUDIT_MGMT To Manage And Purge Audit Information

 

参考至:http://blog.csdn.net/aicon/article/details/8575280

如有错误,欢迎指正

邮箱:czmcj@163.com

In this Document Symptoms Cause Solution References --------------------

  • 0

    开心

    开心

  • 0

    板砖

    板砖

  • 0

    感动

    感动

  • 0

    有用

    有用

  • 0

    疑问

    疑问

  • 0

    难过

    难过

  • 0

    无聊

    无聊

  • 0

    震惊

    震惊

编辑推荐
References and foreach References in PHP are bad, as I mentioned before, and you certainly sh
1使用hibernate和spring MVC 时报错: Caused by: org.springframework.beans.factory.BeanCreationE
1使用hibernate和spring MVC 时报错: Caused by: org.springframework.beans.factory.BeanCreationE
1使用hibernate和spring MVC 时报错: Caused by: org.springframework.beans.factory.BeanCreationE
1使用hibernate和spring MVC 时报错: Caused by: org.springframework.beans.factory.BeanCreationE
1使用hibernate和spring MVC 时报错: Caused by: org.springframework.beans.factory.BeanCreationE
How to solve this HARD issue 1. Problem: A non-empty zero-indexed array A consisting of N int
问题描述 定义栈的数据结构,要求添加一个min函数,能够得到栈的最小元素。 实现栈的push(), pop()
问题描述 求Fibonacci数列的第n项。Fibonacci数列为1,1,2,3,5,... 解决思路 (1) 递归,指数级时间复
Hadoop promises to become a ubiquitous framework for largescale business intelligence, but ri
版权所有 IT知识库 CopyRight © 2009-2015 IT知识库 IT610.com , All Rights Reserved. 京ICP备09083238号