Inserts into Partitioned Table fail with Ora-14400
- From: "Brady, Mark" <Mark.Brady@xxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 30 Aug 2007 16:19:33 -0400
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
>>> This e-mail and any attachments are confidential, may contain legal,
professional or other privileged information, and are intended solely for the
addressee. If you are not the intended recipient, do not use the information
in this e-mail in any way, delete this e-mail and notify the sender. CEG-IP2
Other related posts:
