Re: How to coalesce an LMT TS to drop extra datafiles?

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."

--
http://www.freelists.org/webpage/oracle-l