expdp 导出sys用户下的表报错ORA-39165 和ORA-39166
来源:互联网 发布:淘宝跨店凑单什么意思 编辑:程序博客网 时间:2024/06/03 14:16
expdp 导出sys用户下的表报错ORA-39165 和ORA-39166
在用expdp导出sys用户下的table,结果报错,全部的log 如下:
[oracle@hosta ~]$ expdp sys/**** directory=exp_dir dumpfile=fga_log.dmp logfile=fga_log.log tables=fga_log$Export: Release 11.2.0.3.0 - Production on Thu Jan 17 13:07:23 2014Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.UDE-01017: operation generated ORACLE error 1017ORA-01017: invalid username/password; logon deniedUsername: sys as sysdbaPassword: Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,Data Mining and Real Application Testing optionsStarting "SYS"."SYS_EXPORT_TABLE_01": sys/******** AS SYSDBA directory=exp_dir dumpfile=fga_log.dmp logfile=fga_log.log tables=fga_log$ Estimate in progress using BLOCKS method...Total estimation using BLOCKS method: 0 KBORA-39166: Object SYS.FGA_LOG$ was not found.ORA-31655: no data or metadata objects selected for jobJob "SYS"."SYS_EXPORT_TABLE_01" completed with 2 error(s) at 13:12:8于是就搜到了如下文章:
ataPump Export (EXPDP) Fails With Error ORA-39165 Schema SYS Was Not Found (Doc ID 553402.1)
该文章给出了如下答案:
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.解决该报错的方法是:
1. 使用exp 导出
2.ctas的方法在不受限制的schema下创建表,然后导出该新建的表
3. 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.
注意:This issue also applies to other SYS owned auditing tables such as FGA_LOG$
0 0
- expdp 导出sys用户下的表报错ORA-39165 和ORA-39166
- expdp 导出报错 ORA-39006: ORA-39065: ORA-04063: ORA-06508: ORA-39097: ORA-01403: ORA-39097:
- EXPDP导出数据时报错ORA-12154
- expdp导出报错ORA-39002、ORA-39070解决办法
- expdp导出报错ORA-31693&ORA-39826
- expdp query导出报错 ORA-29913 ORA-01722
- expdp导出报错ORA-39002、ORA-39070解决办法
- EXPDP导出ORA-39127错误
- expdp 导出schema ora-39095
- EXPDP遇到的ORA-39005和ORA-39095错误
- Oracle expdp 报错: ORA-39125 ORA-4063 on View SYS.KU$_CLUSTER_VIEW 解决方法
- plsql修改表报错:ORA-25150
- expdp导出时报错,ORA-12154 TNS: 无法解析指定的连接标识符
- 查询外部表报错ORA-29913 ORA-29400
- expdp/impdp ORA-39002&ORA-39166
- 关于Oracle创建存储过程时,访问不同Schema下的表报错:ORA-00942的问题
- expdp过程中的ORA-31693、ORA-02354和ORA-01555
- impdp/expdp导入导出出现ORA-39006 ORA-39213错误
- Please ensure that adb is correctly located at 问题解决
- Python Excel Tutorial (一):xlrd的安装和读取Excel文件
- 通过JDBC驱动连接Hive操作实例
- BOJ 478 小妹妹采蘑菇
- atitit.压缩算法 ZLib ,gzip ,zip 最佳实践 java .net php
- expdp 导出sys用户下的表报错ORA-39165 和ORA-39166
- 索引组织表和普通表
- UVA 10529 - Dumb Bones(概率+区间dp)
- Mac环境下Nginx+PHP+MySQL的安装与配置
- HDOJ题目2529shot(数学)
- Android高手进阶教程(四)之----Android 中自定义属性(attr.xml,TypedArray)的使用!
- 关于C#中的两个short类型相加变成了int类型
- CSDN博文精选:Android系列开发博客资源汇总
- ref和out的作用和区别