Re: How to coalesce an LMT TS to drop extra datafiles?
From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Fri, 1 Feb 2013 10:04:42 -0700
Message-Id: <72509557-F9F8-4811-9393-675AC939F964_at_centrexcc.com>
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.
>
> 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?
>
Date: Fri, 1 Feb 2013 10:04:42 -0700
Message-Id: <72509557-F9F8-4811-9393-675AC939F964_at_centrexcc.com>
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?
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Feb 01 2013 - 18:04:42 CET