ORA-39166: Object SYS.AUDIT_LOG was not found.ORA-31655: no data or metadata objects selected for jo

最新推荐文章于 2023-05-25 17:59:52 发布

shayuwei

最新推荐文章于 2023-05-25 17:59:52 发布

阅读量966

点赞数

分类专栏：笔记 Oracle 文章标签： oracle

本文链接：https://blog.csdn.net/shayuwei/article/details/106516690

版权

问题描述

将保存审计信息的视图dba_audit_trail转存为表audit_log后导出时报错:

[oracle@testrac1 ~]$ expdp \"/ as sysdba\" directory=dmp_dir  dumpfile=audit_log.dmp tables= audit_log

Export: Release 11.2.0.4.0 - Production on Mon Jun 1 09:13:32 2020

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.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":  "/******** AS SYSDBA" directory=dmp_dir dumpfile=audit_log.dmp tables=
Estimate in progress using BLOCKS method...
Total estimation using BLOCKS method: 0 KB
ORA-39166: Object SYS.AUDIT_LOG was not found.
ORA-31655: no data or metadata objects selected for job
Job "SYS"."SYS_EXPORT_TABLE_01