error while insert [message #393265] |
Sat, 21 March 2009 00:02 |
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 #393291 is a reply to message #393265] |
Sat, 21 March 2009 01:46 |
|
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
|
|
|