Re: Exchange Partition Error

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@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx 
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@xxxxxxxxx> 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@xxxxxxxxx>* wrote:
>
>
> From: Rodd Holman <rodd.holman@xxxxxxxxx>
> Subject: Exchange Partition Error
> To: oracle-l@xxxxxxxxxxxxx
> 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

Other related posts: