Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Inserts into Partitioned Table fail with Ora-14400
Upon re-reading your original post, I see that you didn't mention the
Partition Key datatype, I just assumed it was Date - almost all of ours
are. My suggestion to look at your range definitions for each partition
still hold, whether Date, Number, or whatever.
The other possibility that occurred to me is how you're, perhaps, translating the raw data via the SQL*Loader control file. If the Partition Key data is Date, do you have a SQL function that converts a string value to Date? Perhaps that's not working correctly. If the loaded values aren't Date, might the SQL function be converting a string to Number?
Yet another thought.
Jack C. Applewhite - Database Administrator
Austin I.S.D.
414.9715 (phone) / 935.5929 (pager)
Y@]DZܵ,ڷϵؙ.njռ.@@] ɄeǷǷ.㲻κ¶,}u,ְlȡκЄӻz© ȡه,һNֹ,K`.
Jack Applewhite/CAC/AISD
08/30/2007 05:38 PM
To
Mark.Brady_at_Constellation.Com
cc
oracle-l_at_freelists.org, oracle-l-bounce_at_freelists.org
Subject
Re: Inserts into Partitioned Table fail with Ora-14400
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
Were 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 its not unmappable.
What am I missing?
Thanks,
Mark Brady
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 30 2007 - 22:29:03 CDT
![]() |
![]() |