Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Inserts into Partitioned Table fail with Ora-14400

Re: Inserts into Partitioned Table fail with Ora-14400

From: <JApplewhite_at_austinisd.org>
Date: Thu, 30 Aug 2007 17:38:00 -0500
Message-ID: <OFD959FE7F.F7E23E75-ON86257347.007C1D51-86257347.007C5500@austinisd.org>


Mark,

Are you sure you have all the partitions in-between the Min and Max and that they're defined so that no dates could fall through a crack?

Just a thought.

Jack C. Applewhite
Austin I.S.D.

"Brady, Mark" <Mark.Brady_at_Constellation.Com> Sent by: oracle-l-bounce_at_freelists.org
08/30/2007 04:17 PM
Please respond to
Mark.Brady_at_Constellation.Com

To
<oracle-l_at_freelists.org>
cc

Subject
Inserts into Partitioned Table fail with Ora-14400

We’re inserting records via SQL*Loader into a 9.2.0.6. The table is Range Partitioned.
The last partition is defined as Maxvalue. If you have a maxvalue partition it should not be possible to see Record 8: Rejected - Error on table LEAVES. ORA-14400: inserted partition key does not map to any partition But every record fails.
MaxValue should be just like an “else”, right? And the docs say that Nulls go to maxvalue partitions.
Either the value is less than some partition we defined or less than maxvalue but it’s not unmappable.
What am I missing?

Thanks,
Mark Brady

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Aug 30 2007 - 17:38:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US