RE: Inserts into Partitioned Table fail with Ora-14400

Mark,
 
Have you tried just plain inserting into the table to test it is not a
sql*loader problem? Have you checked the partition that has the maxvalue has
not been dropped inadvertently? See if user_tab_partitions has something to
show regarding your partitions. Just some things I would check.
 
Kind regards,
Eric.

  _____  

Van: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
Namens Brady, Mark
Verzonden: donderdag 30 augustus 2007 22:20
Aan: oracle-l@xxxxxxxxxxxxx
Onderwerp: 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

>>> 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: