Re: Rebuilding the system schema

haganahtrainer_at_gmail.com wrote:
> We have a test instance and a script that was run agains the system
> schema which dropped some of the objects- it seems that the system
> works but some features do not work such as dropping a user - Is there
> a way to rebuild the system schema to get all of the objects back in?

What version?

Likely you can rebuild by running the same installation scripts Oracle uses us as catalog.sql and catproc.sql. But based on the fact that you already did something more than a little destructive I am very hesitant to suggest a course of action as you might just make things worse. Is this a production database?

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org