| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Moving LOBs of a particular partition to a new tablespace
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"
 |
 |