expdp 导出sys用户下的表报错ORA-39165 和ORA-39166

0    233    1

Tags:

👉 本文共约1619个字,系统预计阅读时间或需7分钟。

目录

    expdp 导出 sys 用户下的表报错 ORA-39165 和 ORA-39166
    [oracle@orcltest ~]$ expdp \'/ AS SYSDBA\' directory=DATA_PUMP_DIR tables='SYS.WRH$_ACTIVE_SESSION_HISTORY','SYS.WRM$_SNAPSHOT','SYS.WRH$_EVENT_NAME','SYS.WRH$_SQLCOMMAND_NAME','SYS.WRH$_PLAN_OPERATION_NAME','SYS.WRH$_PLAN_OPTION_NAME','SYS.WRH$_TOPLEVELCALL_NAME' dumpfile=expdp_ash_lhr_01.dmp parfile=/tmp/expdp_ash_lhr_01.par EXCLUDE=STATISTICS VERSION=11.2.0.1 REUSE_DUMPFILES=Y

    Export: Release 11.2.0.3.0 - Production on Fri Dec 16 16:49:52 2016

    Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

    Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
    With the Partitioning, Automatic Storage Management, OLAP, Data Mining
    and Real Application Testing options
    Starting "SYS"."SYS_EXPORT_TABLE_03": "/**** AS SYSDBA" directory=DATA_PUMP_DIR tables=SYS.WRH$_ACTIVE_SESSION_HISTORY,SYS.WRM$_SNAPSHOT,SYS.WRH$_EVENT_NAME,SYS.WRH$_SQLCOMMAND_NAME,SYS.WRH$_PLAN_OPERATION_NAME,SYS.WRH$_PLAN_OPTION_NAME,SYS.WRH$_TOPLEVELCALL_NAME dumpfile=expdp_ash_lhr_01.dmp parfile=/tmp/expdp_ash_lhr_01.par EXCLUDE=STATISTICS VERSION=11.2.0.1 REUSE_DUMPFILES=Y
    Estimate in progress using BLOCKS method...
    Total estimation using BLOCKS method: 0 KB
    ORA-39166: Object SYS.WRH$_ACTIVE_SESSION_HISTORY was not found.
    ORA-39166: Object SYS.WRM$_SNAPSHOT was not found.
    ORA-39166: Object SYS.WRH$_EVENT_NAME was not found.
    ORA-39166: Object SYS.WRH$_SQLCOMMAND_NAME was not found.
    ORA-39166: Object SYS.WRH$_PLAN_OPERATION_NAME was not found.
    ORA-39166: Object SYS.WRH$_PLAN_OPTION_NAME was not found.
    ORA-39166: Object SYS.WRH$_TOPLEVELCALL_NAME was not found.
    ORA-31655: no data or metadata objects selected for job
    Job "SYS"."SYS_EXPORT_TABLE_03" completed with 8 error(s) at 16:49:53

    于是就搜到了如下文章:

    ataPump Export (EXPDP) Fails With Error ORA-39165 Schema SYS Was Not Found (Doc ID 553402.1)

    本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务,私聊QQ646634621或微信db_bao,谢谢!
    expdp 导出sys用户下的表报错ORA-39165 和ORA-39166后续精彩内容已被小麦苗无情隐藏,请输入验证码解锁本站所有文章!
    验证码:
    请先关注本站微信公众号,然后回复“验证码”,获取验证码。在微信里搜索“DB宝”或者“www_xmmup_com”或者微信扫描右侧二维码都可以关注本站微信公众号。

    标签:

    Avatar photo

    小麦苗

    学习或考证,均可联系麦老师,请加微信db_bao或QQ646634621

    您可能还喜欢...

    发表回复

    嘿,我是小麦,需要帮助随时找我哦。
    • 18509239930
    • 个人微信

    • DB宝
    • 个人邮箱
    • 点击加入QQ群
    • 个人微店

    • 回到顶部