首页 > 代码库 > expdp 导出sys用户下的表报错ORA-39165 和ORA-39166
expdp 导出sys用户下的表报错ORA-39165 和ORA-39166
expdp 导出sys用户下的表报错ORA-39165 和ORA-39166
同事在用expdp导出sys用户下的table，结果报错，全部的log 如下：
ataPump Export (EXPDP) Fails With Error ORA-39165 Schema SYS Was Not Found (Doc ID 553402.1)
该文章给出了如下答案：
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$
同事在用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 2014 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. UDE-01017: operation generated ORACLE error 1017 ORA-01017: invalid username/password; logon denied Username: sys as sysdba Password: Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options Starting "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 KB ORA-39166: Object SYS.FGA_LOG$ was not found. ORA-31655: no data or metadata objects selected for job Job "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$
声明：以上内容来自用户投稿及互联网公开渠道收集整理发布，本网站不拥有所有权，未作人工编辑处理，也不承担相关法律责任，若内容有误或涉及侵权可进行投诉： 投诉/举报 工作人员会在5个工作日内联系你，一经查实，本站将立刻删除涉嫌侵权内容。