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
In this Document Symptoms Cause Solution References --------------------
原创wx6323d657ef2b3 博主文章分类:Oracle日常管理 ©著作权
©著作权归作者所有:来自51CTO博客作者wx6323d657ef2b3的原创作品,请联系作者获取转载授权,否则将追究法律责任
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
[全网首发中文版]TextMonkey: An OCRFree Large Multimodal Model for Understanding Document
TextMonkey : An OCR-Free Large Multimodal Model for Understanding Document摘要我们推出了 TextMonkey,这是一种专为以文本为中心的任务而定制的大型多模态模型 (LMM),包括文档问答 (DocVQA) 和场景文本分析。 我们的方法引入了跨多个维度的增强:通过采用零初始化的转移窗口注意力,我们在更高的输入分辨率下实
初始化 Monkey OCR 多模态模型 TextMonkey -
textbook references
* math 1. Teubner-Taschenbuch der Mathematik * CFD
textbook references 干货 -
centos7 怎么安装QQ
Ceph简介 Ceph是一种为优秀的性能、可靠性和可扩展性而设计的统一的、分布式文件系统。 准备工作准备3台主机,并且修改主机名(hostnamectl set-hostname xxx 后重启)IP地址
centos7 怎么安装QQ ceph centos7 CentOS root权限