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
相关推荐
Information in this document applies to any platform. Description The following errors may be reported: ORA-00603: ORACLE server session terminated by fatal error ORA-27504: IPC error creating OSD ...
This book describes how Yunus—in partnership with some of the world's most visionary business leaders—has launched the world's first purposely designed social businesses. From collaborating with ...
- Fixed: The AppDeActivateZOrder patch now fixes the cause instead of the symptoms - Added fix for: Error Insight fails to find TObject class - Added fix for: Possible deadlock when Error Insight ...
基于ML的Flask App用于疾病预测 这是我的最后一个项目,目的是根据给定的症状检测疾病并总结基于EHR的医学报告。 先决条件 您必须已安装Scikit Learn,Pandas(用于机器学习模型),nltk库,pickle和Flask(用于API...
structural health monitoring systems have been developed to measure the loading environment and responses of these bridges in order to assess serviceability and safety while tracking the symptoms of ...
In this scenario, since T1 believes it locks the entire table, it might inadvertently make changes to the same row that T2 thought it has locked exclusively. In a multigranular locking environment, ...
This holds especially for safety related processes like aircraft, trains, automobiles, power plants and chemical plants. The classical approaches are limit or trend checking of some measurable output...
Troubleshooting with Wireshark: Locate the Source of... In addition, wherever possible we list off the potential cause(s) of these problems. Book Details Paperback ISBN: 978-1-893939-9-74 Page Count: 408
Distinguished by its practice-oriented approach to neurology based on the patients' presenting symptoms, this classic has been updated and revised to make it even more clinically-relevant and ...
If your team is struggling with any of these symptoms, these four case studies will guide you to project success. See how Kanban was used to significantly improve time to market and to create a ...
Clearly structured and organized by major organ system, the book emphasises ways in which key signs and symptoms of disease inform diagnosis and the choice of treatment, together with the relevant ...
Symptoms Rootpre.sh was run. Output of rootpre.sh shows below message: Checking if group services should be configured.... ODMDIR=/etc/objrepos, isSP= 0, isHACMP= 0 Nothing to configure.
医学专家系统知识基础 使用专家系统外壳开发专家系统。 这些外壳是空的Expert System知识库,其结构和接口已经为我们编写。 我们需要做的就是将知识添加到知识库中。 为了解决这个问题,我们将使用一个小的...
可以在以下kaggle链接中找到数据: ://www.kaggle.com/sammy123/lower-back-pain-symptoms-dataset抽象的下腰痛的治疗和预防在国际上仍然是初级保健的一个挑战,因为它被认为是全球第二广泛传播的疾病。...
according to the main technical solution used in the algorithm. This paper is expected to be useful to researchers working both on vegetable pathology and pattern recognition, providing a ...
In this preface, I’ll tell you about the history of Minimal Perl and the origins of this book. THE HISTORY OF MINIMAL PERL The seeds of this book were sown many years ago, when I was building up my ...
You'll get reassuring, sound advice and self-help techniques that you and your loved ones, including kids and teens, can use to ease and eliminate symptoms, function in times of crisis, plan ahead ...
Children of Alcoholics 123... Childhood symptoms in children of alcoholics and comparison group parents. Journal of Marriagh and the Family, 28, 152-154. JONESJ, . W. (1981). The Children of Alcoholics
Dialysis hypotension is one of the most prevalence symptoms of dialysis and occurs in 40% of treatment sessions. Detection and prediction of hypotension is important for the well-being of the patient ...