expdp ORA-39165: Schema DBSNMP was not found
来源:互联网 发布:淘宝卖二手书 编辑:程序博客网 时间:2024/04/30 09:37
修改时间:2012-11-23类型:PROBLEM状态:PUBLISHED优先级:3 注释 (0)
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
- expdp ORA-39165: Schema DBSNMP was not found
- IMPDP :Schema XXX was not found
- expdp 导出schema ora-39095
- Microsoft.Data.Schema.SqlTasks.targets was not found 解决方法
- 解决ORA-39166: Object CCXE.RR_JYRESEARCHREPORT was not found错误
- ORA-39168: Object path STATISTICS was not found.
- 解决ORA-39166: Object CCXE.RR_JYRESEARCHREPORT was not found错误
- libz was not found
- bisonExe was not found
- ORA-06512 DBSNMP.BSLN_INTERNAL
- ORA-31603: object "orders" of type TABLE not found in schema "SYSTEM"
- Image file was not found.
- NOT_FOUND_ERR:Node was not found
- NotFoundError: Node was not found
- ORA-06512: at "DBSNMP.BSLN_INTERNAL"
- ORA-06512: at "DBSNMP.BSLN_INTERNAL",
- SQL0805N Package "NULLID.SQLLD003" was not found.
- the disk was not found(Altiris)
- 笔记本应用电视机屏幕看电影
- “石油无机论”颠覆对于石油的认知
- 使C++ Builder编译程度独立运行
- 移动互联网——让用户少点击一次
- 思科预计移动连接设备的数量将在2013年底超出范围
- expdp ORA-39165: Schema DBSNMP was not found
- 谁是你的潜在朋友
- HDT_2029 Palindromes _easy version
- JQuery EsayUI ComboBox 在chrome 报 An invalid form control with name='' is not focusable.
- 文件IO消耗分析
- Centos利用yum命令安装配置MySQL+Apache+PHP
- js整数,小数转换
- Jquery EasyUI后台实例
- 大佬们看2013互联网走势