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

Home -> Community -> Mailing Lists -> Oracle-L -> Moving LOBs of a particular partition to a new tablespace

Moving LOBs of a particular partition to a new tablespace

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Mon, 29 Mar 2004 10:47:12 -0500
Message-ID: <4C9B6FDA0B06FE4DAF5918BBF0AD82CFECFC66@bosmail00.bos.il.pqe>


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 <table> move partition <Partition> lob(<LOB column>) store as (tablespace <new TS>); 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_at_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
Received on Mon Mar 29 2004 - 09:43:42 CST

Original text of this message

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