Re: How to coalesce an LMT TS to drop extra datafiles?
- From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx List" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 1 Feb 2013 08:37:14 -0700
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
