From oracle-l-bounce@freelists.org Mon Mar 29 09:43:42 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2TFhgV22321 for ; Mon, 29 Mar 2004 09:43:42 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i2TFhfo22313 for ; Mon, 29 Mar 2004 09:43:42 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E573A6343A2; Mon, 29 Mar 2004 10:40:27 -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 26732-60; Mon, 29 Mar 2004 10:40:27 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id ED0E163439F; Mon, 29 Mar 2004 10:40:26 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 29 Mar 2004 10:39:16 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B24746342E4 for ; Mon, 29 Mar 2004 10:39:15 -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 26985-33 for ; Mon, 29 Mar 2004 10:39:15 -0500 (EST) Received: from tera.umi.com (tera.umi.com [192.195.245.144]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4D7F36341B9 for ; Mon, 29 Mar 2004 10:39:15 -0500 (EST) Received: from bosmail02.bos.il.pqe (bosmail02.bos.il.pqe [172.24.3.66]) by tera.umi.com (8.11.6/8.11.6) with ESMTP id i2TFlB905987 for ; Mon, 29 Mar 2004 10:47:11 -0500 Received: from bosmail00.bos.il.pqe ([172.24.3.64]) by bosmail02.bos.il.pqe with Microsoft SMTPSVC(5.0.2195.6713); Mon, 29 Mar 2004 10:47:12 -0500 X-MimeOLE: Produced By Microsoft Exchange V6.0.6249.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Subject: Moving LOBs of a particular partition to a new tablespace Date: Mon, 29 Mar 2004 10:47:12 -0500 Message-ID: <4C9B6FDA0B06FE4DAF5918BBF0AD82CFECFC66@bosmail00.bos.il.pqe> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Moving LOBs of a particular partition to a new tablespace Thread-Index: AcQVpRoixXJ7Ey6aSyC1lX6jE0NaRw== From: "Bobak, Mark" To: X-OriginalArrivalTime: 29 Mar 2004 15:47:12.0773 (UTC) FILETIME=[1A44F350:01C415A5] X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 1974 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Mark.Bobak@il.proquest.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Hi people, One of my colleagues is having a problem moving LOBs to a new tablespace. He's trying to move JUST the LOBs in a particular partition of a table to a new tablespace, WITHOUT affecting the entire partition. The following syntax: alter table t1 move partition p1 to ts_p1; Will move the partition contents to ts_p1 but not the LOB segments associated with that partition. So, then he tried: alter table move partition lob() store as (tablespace ); which works, but, in addition to moving the LOB segments to the appropriate tablespace, also moves the partition in place in it's own tablespace. Due to the size of the partition, this considerably increases the time required for the operation to complete, not to mention the invalidation of all requisite indexes, and the additional space required for the partition move to be successful Does anyone have any ideas or suggestions as to how to move ONLY the LOB segments? Thanks, -Mark PS This was posted on MetaLink a week ago, and has been met with a resounding silence....;-) Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI "Post Hoc Ergo Propter Hoc" ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------