Re: How to coalesce an LMT TS to drop extra datafiles?
- From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- To: fuzzy.graybeard@xxxxxxxxx
- Date: Fri, 1 Feb 2013 09:33:34 -0700
Thanks Hans,
I forgot ( to mention ) that "rebuild index(es)" part of the alter table move
operation.
You must live in a blessed world/environment(s) where people know why a
particular index exists. In my world people who might have known that have left
the company, or fell victim of a "rightsizing", 8 years ago.
On 2013-02-01, at 9:11 AM, Hans Forbrich wrote:
> 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: