Re: export/import partitions

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 28 Jun 1999 11:15:12 +0100
Message-ID: <930565243.17847.0.nnrp-06.9e984b29@news.demon.co.uk>

If the partitioned table is:

        values < 1st jan
       values < 1st Feb
        values < 1st march

etc,
and you mean

    values < 1st Jan by 'the back end of the partition'. then the answer is NO.

If you drop this partition, then import the data, it will go into the 'values < 1st Feb' partition. To get the 'values < 1st Jan' partition back, you would have to SPLIT PARTITION for the 'values < 1st Feb' at 1st Jan, and this would invalidate the Feb partition and its indexes and probably take quite some time.

You idea of truncating the partition is the better option.

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

pauldb wrote in message <930564100.26874_at_www.remarq.com>...
>If i export a partition at the back end of the table
>(according to partition key) and then drop the partition,
>can i just re-import that partition.
Received on Mon Jun 28 1999 - 05:15:12 CDT