Search code examples
oracle-databasepackagesystem

How can I reinstall a system PL/SQL package in Oracle?


I have noticed that if someone overwrites or deletes a system package you cannot recover the initial code. In my case, I have lost DBMS_OUTPUT package. Does anyone knows how to reinstall it ?


Solution

  • The package is created with the scripts dbmsotpt.sql (package spec) and then prvtotpt.plb (package body), though I have never executed these scripts directly. The scripts can be found under /rdbms/admin.