RE: WEBSYS Schema
- From: "Ken Naim" <kennaim@xxxxxxxxx>
- To: <sbootsma@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 7 Jul 2005 15:18:52 -0500
Seems like it a oracle apps account or and oracle warehouse builder account.
_____
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Sam Bootsma
Sent: Thursday, July 07, 2005 2:52 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: WEBSYS Schema
Oracle 9.2.0.6; AIX 5
Does anybody know what the WEBSYS schema is all about? I did a search on
Oracle's online 9.2 documentation, but it returned no hits. Is it an
obsolete Oracle schema?
On our database this schema has 4 tables and 4 indexes plus some packages
and views. Seven of the tables and indexes are in the SYSTEM tablespace,
but the index PK_OWS_OBJECT is in the USERS tablespace - and this is
creating problems for me. I want to drop the USERS tablespace, including
contents, but it won't let me because of this primary key. I could export,
remove all sorts of privileges, and force all the objects to go into the
SYSTEM tablespace. But if this schema is not needed, it will be simpler
just to drop it and not worry about it. Of course, I would also confirm
with our Developers that we are not using it.
Thanks,
Sam Bootsma
George Brown College
<mailto:sbootsma@xxxxxxxxxxxxx> sbootsma@xxxxxxxxxxxxx
416-415-5000 x4933
Other related posts:
