Re: How to coalesce an LMT TS to drop extra datafiles?
From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Fri, 1 Feb 2013 08:37:14 -0700
Message-Id: <FCDB71D7-F230-46E9-9D53-728988F528C6_at_centrexcc.com>
resending because of over quoting
>> Hey all,
>>
>> In 11.2.0.3.0, we're archiving older data. This first phase will include
>> deleting (archiving) about 4 years of data. Ongoing archiving will then
>> delete the oldest 6 months of data. Since our DB grows very linearly, I
>> expect table sizes to be very stable from then on.
>>
>> Is there any way short of moving massive numbers segments out of the TS to
>> tell Oracle I'd like to drop datafiles? There's about 3400 tables that have
>> their respective extents intermingled in those datafiles, with ~3100 of them
>> being a single extent in the first datafile.
Date: Fri, 1 Feb 2013 08:37:14 -0700
Message-Id: <FCDB71D7-F230-46E9-9D53-728988F528C6_at_centrexcc.com>
resending because of over quoting
On 2013-02-01, at 8:35 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. > > On 2013-02-01, at 8:15 AM, Rich Jesse wrote: >
>> Hey all,
>>
>> In 11.2.0.3.0, we're archiving older data. This first phase will include
>> deleting (archiving) about 4 years of data. Ongoing archiving will then
>> delete the oldest 6 months of data. Since our DB grows very linearly, I
>> expect table sizes to be very stable from then on.
>>
>> Is there any way short of moving massive numbers segments out of the TS to
>> tell Oracle I'd like to drop datafiles? There's about 3400 tables that have
>> their respective extents intermingled in those datafiles, with ~3100 of them
>> being a single extent in the first datafile.
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Feb 01 2013 - 16:37:14 CET