Re: DBMS_REPAIR, 8.1.7

John Oakes wrote:

> Object does not exist.  Why?  What schema should it be located in?
> 
> <snipped>

DBMS_REPAIR is owned by SYS and built with the creation of the SYSTEM tablespace. If it isn't there ...

SELECT COUNT(*)
FROM dba_objects
WHERE object_name = 'DBMS_REPAIR';

Then shut the database down ASAP.
Log back on as SYS and bring it back up in restricted mode Then run catalog.sql and catproc.sql before letting anyone touch anything.

If DBMS_REPAIR is missing one can only wonder at what else may be missing too.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)