Re: Unnecessary Users and Schemas?

This is on my personal PC and if I don't need to waste the space on schemas and users I'll never use I'd rather not have them there. This is for my Designer 9i repository so actually the only schemas that are really used would be SYSTEM, SYS and DES (which is my repository owner).

I don't know if it's reverse engineering my instance as much as being "brave" now that I actually have a bit more understanding of the workings of Oracle. Up till now, other than the programming side my only knowledge on the administrative aspect of Oracle has been from what I've read in my books. I've been taking classes with the goal of getting certified in 10G database administration so I have a little bit more understanding of what things do and more confident I can recover if I make a mistake.

"Frank van Bortel" <frank.van.bortel_at_gmail.com> wrote in message news:dv0ui6$7h6$1_at_news3.zwoll1.ov.home.nl...
> Dereck L. Dietz wrote:
> > In my Designer 9i repository I've identified a number of Users and
Schemas
> > that I'm wondering if I could remove without damage. I've already
removed
> > the HR and SCOTT schemas since I know those aren't necessary but I have
> > questions on a number of other users.
> >
> > Can anybody tell me which of the following users and their schemas are
safe
> > to remove?:
> >
> > USER DEFAULT TABLESPACE
> > --------------- ----------------------------
> > ANONYMOUS XDB
> > CTXSYS DRSYS
> > DBSNMP SYSTEM
> > MDSYS SYSTEM
> > ODM ODM
> > ODM_MTR ODM
> > OE EXAMPLE
> > OLAPSYS CWMLITE
> > ORDPLUGINS SYSTEM
> > ORDSYS SYSTEM
> > OUTLINE SYSTEM
> > PM EXAMPLE
> > QS EXAMPLE
> > QS_ADM EXAMPLE
> > QS_CB EXAMPLE
> > QS_CBADM EXAMPLE
> > QS_CS EXAMPLE
> > QS_ES EXAMPLE
> > QS_OS EXAMPLE
> > QS_WS EXAMPLE
> > SH EXAMPLE
> > WKPROXY DRSYS
> > WKSYS DRSYS
> > WMSYS SYSTEM
> > XDB XDB
> >
> >
>
> You have been reverse engineering your instance :)
>
> You can drop all users above from your repository.
>
> Unless, of course, you are in the process of actually
> designing something for one of them, but I would recommend
> creating a new user within the repository if you insist
> on having one (or none at all).
> --
> Regards,
> Frank van Bortel
>
> Top-posting is one way to shut me up...
Received on Sun Mar 12 2006 - 08:38:15 CST