Re: How to coalesce an LMT TS to drop extra datafiles?
- From: Hans Forbrich <fuzzy.graybeard@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 01 Feb 2013 09:11:29 -0700
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."
--
//www.freelists.org/webpage/oracle-l
Other related posts:
