Home » SQL & PL/SQL » SQL & PL/SQL » error while insert (oracle 10g)
error while insert [message #393265] Sat, 21 March 2009 00:02 Go to next message
ravi214u
Messages: 153
Registered: February 2008
Location: CANADA
Senior Member
hi all,

i am getting error while inserting a record in to fact table.
I understand that error is related to partition but there is no partition on this table please advice
ORA-14400: inserted partition key does not map to any partition


thanks
Re: error while insert [message #393275 is a reply to message #393265] Sat, 21 March 2009 01:19 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
You have table & DDL. We don't
You have data & DML. We don't.
You have code. We don't.


You have ALL the information & can't debug the problem.
Why do you expect others, who have NO details, to answer your mystery?

All you provide is error message.
You have that & deem it not sufficient to solve mystery.
Why do you expect solution here?
Re: error while insert [message #393291 is a reply to message #393265] Sat, 21 March 2009 01:46 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
ORA-14400: inserted partition key does not map to any partition
 *Cause:  An attempt was made to insert a record into, a Range or Composite
          Range object, with a concatenated partition key that is beyond
          the concatenated partition bound list of the last partition -OR-
          An attempt was made to insert a record into a List object with
          a partition key that did not match the literal values specified
          for any of the partitions.
 *Action: Do not insert the key. Or, add a partition capable of accepting
          the key, Or add values matching the key to a partition specification

Regards
Michel
Previous Topic: Beginner: How to write this trigger?
Next Topic: query
Goto Forum:
  


Current Time: Sun Dec 08 06:25:23 CST 2024