Q
Manage Learn to apply best practices and optimize your operations.

How to rebuild a built-in Oracle package body

Oracle expert Brian Peasland explains what commands to use in order to rebuild a built-in Oracle package body.

How do I rebuild an Oracle built-in package body? (ex: DBMS_IJOB,DBMS_IREFRESH..) Somehow I lost my DBMS_IJOB package body, and with this I was not able to take full export(FULL=Y).
As with any package or procedure, you can try to recompile the object:

ALTER PACKAGE pkg_name RECOMPILE;

If that does not fix the problem, then try the following in SQL*Plus:

connect / as sysdba
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql

This was last published in December 2008

Dig Deeper on Oracle database administration

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close