Re: Exchange Partition Error

From: David Fitzjarrell <oratune_at_yahoo.com>
Date: Wed, 2 May 2012 12:37:34 -0700 (PDT)
Message-ID: <1335987454.68551.YahooMailNeo_at_web160902.mail.bf1.yahoo.com>

I haven't seen any Oracle version information posted on this; I texted the procedure on 11.2.0.3 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 11.2.0.3 and the procedure provides the neceassary detaile to fix the issue.

David Fitzjarrell

---

From: Rodd Holman <rodd.holman_at_gmail.com> To: oracle-l_at_freelists.org
Sent: Wednesday, May 2, 2012 12:08 PM
Subject: Re: Exchange Partition Error

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

> Rodd,
>
>    Sorry a little late on this,  found this website:
> http://www.oramoss.com/blog/labels/partitioning.html
>
> 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 <rodd.holman_at_gmail.com>* wrote:
>
>
> From: Rodd Holman <rodd.holman_at_gmail.com>
> Subject: Exchange Partition Error
> To: oracle-l_at_freelists.org
> 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.
> ...
>
>

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

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