Re: Exchange Partition Error

From: David Fitzjarrell <>
Date: Wed, 2 May 2012 12:37:34 -0700 (PDT)
Message-ID: <>

I haven't seen any Oracle version information posted on this; I texted the procedure on with the example posted on the blog and the NOT NULL issue in earlier releases isn't an issue anymore as the partitions exchanged without error prior to the 'fix'.  Changing the script slightly if the column definitions are off (say one  has a  number(9) and another declares the same column as number(7)) then the exchange will fail in and the procedure provides the neceassary detaile to fix the issue.

David Fitzjarrell

From: Rodd Holman <> To:
Sent: Wednesday, May 2, 2012 12:08 PM
Subject: Re: Exchange Partition Error

That definitely looks like what we are facing here.  I'm going to check out that checker procedure some more.
On Wed, May 2, 2012 at 9:19 AM, mike boligan <> wrote:

> Rodd,
>    Sorry a little late on this,  found this website:
> Check the third blog entry, there is a checker_script which was used to
> find the problem you are trying to solve.
> Mike
> --- On *Mon, 4/30/12, Rodd Holman <>* wrote:
> From: Rodd Holman <>
> Subject: Exchange Partition Error
> To:
> Date: Monday, April 30, 2012, 2:41 PM
> Hello listers,
> I'm at a bit of a quandry here.  We have a DW load process that uses
> exchange partition to load the fact table.
> ...

Received on Wed May 02 2012 - 14:37:34 CDT

Original text of this message