Re: Oracle8 Partitioning

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 23 Apr 1999 07:11:16 +0100
Message-ID: <924848016.551.0.nnrp-13.9e984b29@news.demon.co.uk>

There is an option to avoid index rebuilds, syntax of the form:

alter table part_table

       exchange partition jan_1999 for part_table_stub
        without validation
        including indexes;

The 'without validation' and 'including indexes' are independent options, but if you can guarantee the part_table_stub matches the requirement of the partition table, then using both is the fast, and most convenient way of handling the task.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk Received on Fri Apr 23 1999 - 01:11:16 CDT