Re: Rebuilding the system schema

From: Mark D Powell <>
Date: Wed, 21 May 2008 10:20:53 -0700 (PDT)
Message-ID: <>

On May 21, 12:35 pm, DA Morgan <> wrote:
> 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
> (replace x with u to respond)
> Puget Sound Oracle Users

Note that changes to user system objects should not interfer with your ability to execute CREATE USER commands as long as the username running the command has the privilege. By "system schema" do you mean username = SYSTEM or SYS?

If system, then do you have an export?

If SYS then running catalog and catproc plus any optional featues created via dbms_ scripts would be my approach.

If that does not work then re-create the database and reload it from an export since this is test that should be good enough.

HTH -- Mark D Powell -- Received on Wed May 21 2008 - 12:20:53 CDT

Original text of this message