Re: extra schemas in system tablespace

From: Philip Chee <philip_at_aleytys.pc.my>
Date: Fri, 26 Nov 99 17:29:20 GMT
Message-ID: <943637360.4953snx@aleytys.pc.my>

In article <81m3mn$9ns$1_at_news.auracom.net> jjohnson_at_deltaware.com writes:

>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?????

They don't look like standard Oracle Financials user/roles created by the OF install programme. As far as OF is concerned you could drop them without problems. There may be other custom stuff related to these users. Are you running Oracle Discoverer? What tables are in the CN/CS/CE schemas?

Philip

---=====================================================================---

 Philip Chee: Tasek Corporation Berhad, P.O.Box 254, 30908 Ipoh, MALAYSIA   e-mail: philip_at_aleytys.pc.my Voice:+60-5-545-1011 Fax:+60-5-547-3932    Guard us from the she-wolf and the wolf, and guard us from the thief,

                  oh Night, and so be good for us to pass.

---
 þ 10148.74 þ Fatal Database Error #10070: Sysop late for work Received on Fri Nov 26 1999 - 11:29:20 CST