CODEWITHSUNDEEP
oracle-databasepackagesystem
Bender78GS
Bender78GS

Reputation: 13

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 ?

Upvotes: 1

Views: 168

Answers (1)

oisene
oisene

Reputation: 211

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.

Upvotes: 3

Related Questions