From oracle-l-bounce@freelists.org Thu Jul 7 14:54:34 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j67JsYjQ015525 for ; Thu, 7 Jul 2005 14:54:34 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j67JsRIP015497 for ; Thu, 7 Jul 2005 14:54:28 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 845531CA30F; Thu, 7 Jul 2005 14:54:20 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 19249-10; Thu, 7 Jul 2005 14:54:20 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0235C1CA765; Thu, 7 Jul 2005 14:54:19 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.0.6487.1 Content-Class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5832D.63976C62" Subject: WEBSYS Schema Date: Thu, 7 Jul 2005 15:52:21 -0400 Message-ID: <4B0639DD5CB28142BFC2CAF1BDE3AB25084D1C12@post.gbrownc.on.ca> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: WEBSYS Schema Thread-Index: AcWDLWOaIijXeO+SRHO/KsC12A44tA== From: "Sam Bootsma" To: X-OriginalArrivalTime: 07 Jul 2005 19:53:13.0343 (UTC) FILETIME=[8256F0F0:01C5832D] X-archive-position: 22211 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: sbootsma@gbrownc.on.ca Precedence: normal Reply-To: sbootsma@gbrownc.on.ca X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-3.7 required=5.0 tests=AWL,BAYES_00,HTML_50_60, HTML_FONTCOLOR_UNKNOWN,HTML_MESSAGE autolearn=no version=2.63 ------_=_NextPart_001_01C5832D.63976C62 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Oracle 9.2.0.6; AIX 5 =20 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? =20 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. =20 Thanks, =20 Sam Bootsma George Brown College sbootsma@gbrownc.on.ca =20 416-415-5000 x4933 =20 ------_=_NextPart_001_01C5832D.63976C62 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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 Br= own Co= llege

sbootsma@gbrownc.on.ca

416-415-5000 = x4933

=00 ------_=_NextPart_001_01C5832D.63976C62-- -- http://www.freelists.org/webpage/oracle-l