Re: defrag needed

From: Ban Spam <ban-spam_at_operamail.com>
Date: Wed, 22 Aug 2001 00:03:30 GMT
Message-ID: <Xns9104AD86834E6SunnySD@24.0.3.73>

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in news:998295200.5883.0.nnrp-12.9e984b29_at_news.demon.co.uk: [...snip...]
>
> The code/test cost of implementing a
> table rebuild is pretty small by comparison.
> (BTW - use MOVE table rather than
> copy and rename - it eliminates the
> hassle of sorting out privileges and
> invalidations due to dependencies).
>

If the source table in an ALTER TABLE table_name MOVE is partitioned, will the destination table also be partitioned?

What happens if/when the source table is partitioned across multiple tablespaces? Received on Tue Aug 21 2001 - 19:03:30 CDT