Re: Inserts into Partitioned Table fail with Ora-14400
- From: JApplewhite@xxxxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 30 Aug 2007 22:29:03 -0500
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料?@封??子?]件是保密的,可在法律上的特??.它是???槭占?人.?@得?@封??子?]件
是由?e人是非法的.如果你不打算接受任何披露,?}?u,分?l或?袢∪魏涡??踊蜻z漏??
?袢〉囊蕾?,是一?N禁止,?K可能?`法.
Jack Applewhite/CAC/AISD
08/30/2007 05:38 PM
To
Mark.Brady@xxxxxxxxxxxxxxxxx
cc
oracle-l@xxxxxxxxxxxxx, oracle-l-bounce@xxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxx>
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
08/30/2007 04:17 PM
Please respond to
Mark.Brady@xxxxxxxxxxxxxxxxx
To
<oracle-l@xxxxxxxxxxxxx>
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
Other related posts:
