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 ?

CodePudding user response：

Rather than waiting for someone to find a link to the DBMS_OUTPUT source code (which may be proprietary and not be publicly available), it may be quicker to:

1. Backup your database and control files.
2. Reinstall the database.
3. Restore from backups.

CodePudding user response：

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.