Re: extra schemas in system tablespace

Don't do this - CE ( at least) has some views needed by AR, depending on how you've done your setups.

Export/import.

Don Siders wrote:

> John Johnson wrote in message <81m3mn$9ns$1_at_news.auracom.net>...
> >I have recently been assigned the task of cleaning up an Oracle Financial
> >Database running on Digital.
> >I have found 3 users (CN,CS,CE) in the system tablespace, does anyone have
> a
> >quick fix for this?????
>
> NOTE: Make sure you really want to remove this user and its data objects.
> You can remove the user and schema objects using:
>
> DROP USER CN CASCADE;
> DROP USER CS CASCADE;
> DROP USER CE CASCADE;
>
> Regards,
>
> Don

--

John Clarke                             (888) 363.2955
Managing Principal Consultant           (248) 593.9935
Centroid Systems, Inc.                  jclarke_at_centroidsys.com
===============================================================