Re: How to coalesce an LMT TS to drop extra datafiles?
- From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- To: rjoralist2@xxxxxxxxxxxxxxxxxxxxx
- Date: Fri, 1 Feb 2013 10:04:42 -0700
Yes, the drawback of the "alter table move" method is that you temporarily need
additional space and each table is locked for the duration of the move. How
long that is depends, of course, on the size of the segment. But segment moves
are surprisingly fast.
I didn't need to go the dbms_redefinition route when I had to do it.
On 2013-02-01, at 9:54 AM, Rich Jesse wrote:
> Wolfgang posts:
>
>> I forgot ( to mention ) that "rebuild index(es)" part of the alter table
>> move operation.
>
> I've resigned myself to the fact that I'm going to have to move the tables
> once shrunk. But as MOVE operations require exclusive locks during the
> operation, I was considering DBMS_REDEFINITION. (DB is EE if there's
> restrictions) I like the idea of online moving all segments to the new TS
> then taking a short outage to rename/cleanup/etc.
>
> Anyone used that package before? Any gotchas or bugs?
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
