DBMS_METADATA和其他包无效 [英] DBMS_METADATA and other packages invalid

问题描述

我在我的本地系统上运行数据库，并通过我的笔记本电脑在家庭网络中访问它。今天，我碰巧检查SYS对象的状态，发现DBMS_METADATA和DATA_PUMP包是无效的。我也无法运行EXPDP实用程序。
有关如何重新编译此对象并更正状态的任何想法？

I am running a database on my local system, and accessing it through my laptop in home network. Today, I happened to check the status of SYS objects, and found that DBMS_METADATA, and DATA_PUMP packages were invalid among others. I am unable to run EXPDP utilities as well. Any ideas on how to recompile this object and correct the status?

感谢您的帮助！

推荐答案

我终于搞清楚了 - 虽然这是一个强力的方法。在管理工具里面，我不得不运行catalog.sql和catproc.sql - 它重新创建了sys对象。

Well I finally figured it out - although this is a bit of a brute force method. Inside the admin tools, I had to run catalog.sql and catproc.sql - which re-created the sys objects.

这是utlrp.sql解析了我所有的问题，现在所有对象都已成功编译。

This, followed by utlrp.sql resolved all my problems, and now all objects are succesfully compiled.

这篇关于DBMS_METADATA和其他包无效的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！