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

Dereck L. Dietz wrote:
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...

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 (DOT) com> wrote

Dereck L. Dietz wrote:
Please, do not top post.

Let's make quite clear that it is my understanding, you
have all these users defined within the Designer repository.

They also are defined on RDBMS level.

Your statement about conserving space would only be valid
when you drop these users from the database. I hope it is
obvious to you, you cannot drop all users from the rdbms.

You can drop all users which have the EXAMPLE tablespace
as default tablespace, along with the actual tablespace
EXAMPLE, and the associated datafile.

That will save space. It merely dropping of users, be it
from your designer repository, or from the database, will
not conserve space on your laptop.

--
Regards,
Frank van Bortel

Top-posting is one way to shut me up...