Re: How to coalesce an LMT TS to drop extra datafiles?

From: Rich Jesse <rjoralist2_at_society.servebeer.com>
Date: Fri, 1 Feb 2013 10:54:50 -0600 (CST)
Message-ID: <44ebb9f0599d303cd55d9ae91c7cd41a.squirrel_at_society.servebeer.com>

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?

Thanks all for the input so far!

Rich

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Feb 01 2013 - 17:54:50 CET

This message: [ Message body ]
Next message: Wolfgang Breitling: "Re: How to coalesce an LMT TS to drop extra datafiles?"
Previous message: Wolfgang Breitling: "Re: How to coalesce an LMT TS to drop extra datafiles?"
In reply to: Wolfgang Breitling: "Re: How to coalesce an LMT TS to drop extra datafiles?"
Next in thread: Wolfgang Breitling: "Re: How to coalesce an LMT TS to drop extra datafiles?"
Reply: Wolfgang Breitling: "Re: How to coalesce an LMT TS to drop extra datafiles?"
Reply: rjamya: "Re: How to coalesce an LMT TS to drop extra datafiles?"
Reply: TJ Kiernan: "RE: How to coalesce an LMT TS to drop extra datafiles?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message