Re: How to coalesce an LMT TS to drop extra datafiles?
From: Hans Forbrich <fuzzy.graybeard_at_gmail.com>
Date: Fri, 01 Feb 2013 09:11:29 -0700
Message-ID: <510BE931.90102_at_gmail.com>
On 01/02/2013 8:37 AM, Wolfgang Breitling wrote:
>> Provided you have the space ( temporarily ) and no long columns, creating a new tablespace, moving all segments from the old to the new ( lobs need to be moved on their own ) and dropping the old. Optionally renaming the new to the old if tablespace names are important.
>>
I second that: Alter Table Move ...
Date: Fri, 01 Feb 2013 09:11:29 -0700
Message-ID: <510BE931.90102_at_gmail.com>
On 01/02/2013 8:37 AM, Wolfgang Breitling wrote:
>> Provided you have the space ( temporarily ) and no long columns, creating a new tablespace, moving all segments from the old to the new ( lobs need to be moved on their own ) and dropping the old. Optionally renaming the new to the old if tablespace names are important.
>>
I second that: Alter Table Move ...
With the added advantage of being able to review which indexes are still required. Why move/rebuild them if they are no longer in use?
"Why do we have that index?"
"Well, we needed it for that report."
"But we stopped using that report 8 months ago."
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Feb 01 2013 - 17:11:29 CET