Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: extra schemas in system tablespace

Re: extra schemas in system tablespace

From: Don Siders <dsiders_at_earth1.net>
Date: Sun, 28 Nov 1999 03:51:53 -0500
Message-ID: <oh704.789$3j5.4647@newsfeed.slurp.net>

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 Received on Sun Nov 28 1999 - 02:51:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US