Solved

ORA-14400: Inserted partition key does not map to any partition

Posted on 2012-03-14
11
4,037 Views
Last Modified: 2012-03-19
Hi,

What advice can you give me about this error message?: "ORA-14400: Inserted partition key does not map to any partition."

TIA,
N.
0
Comment
Question by:Nakuru1234
  • 4
  • 4
  • 3
11 Comments
 
LVL 15

Accepted Solution

by:
Walter Ritzel earned 400 total points
Comment Utility
According to this URL: http://ora-14400.ora-code.com/ ,
seems that you have a partitioned table, were you have possibly defined certain values for the partition key, but when inserting the data, you are not respecting this set of values.
The solution should be use the appropriated values.
There are other interpretations that could fit in your case as well.
0
 
LVL 15

Assisted Solution

by:Walter Ritzel
Walter Ritzel earned 400 total points
Comment Utility
0
 

Author Comment

by:Nakuru1234
Comment Utility
Hi,

Your answer is straight from the internet website...

TIA,
N.
0
 
LVL 15

Expert Comment

by:Walter Ritzel
Comment Utility
Yes, it is because your problem is a documented one. Did you check to see if this solves your issue?
0
 
LVL 31

Expert Comment

by:awking00
Comment Utility
Is this occurring doing an insert from another table or from running sqlloader or some other instance? What is the code you're using that generated this error?
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:Nakuru1234
Comment Utility
It is occuring when doing an insert from another table. I was using a select statement.

TIA,
N.
0
 
LVL 31

Assisted Solution

by:awking00
awking00 earned 100 total points
Comment Utility
You can compare the max(high_value) from user_tab_partitions where table_name = 'YOURTARGETTABLE' to the max(column_value) from your source table where the column_value represents the value going into your partition key. If the column_value is greater, then you need to add a new partition to your target table. Can you post the relevant two table structures to include the partition key fields in both?
0
 
LVL 15

Assisted Solution

by:Walter Ritzel
Walter Ritzel earned 400 total points
Comment Utility
Nakuru1234,
please do as requested by Awking00. His point is exactly same as mine. If you look into the last link I've provided, you will have enough explanation to understand your problem.

Also, if the problem is the one reported on that link, your solution would be:
1) change the partition to support more values;
2) restrict the field causing issue to receive only the values allowed (depending on the situation, a simple constraint will help).
0
 

Author Comment

by:Nakuru1234
Comment Utility
I used exp / imp to go around the problem and that worked ok. Thank you for your help!

TIA,
N
0
 
LVL 31

Expert Comment

by:awking00
Comment Utility
That raises a couple of questions. Was your source table partitioned? If not, then your new target table is not. Does it need to be or should be partitioned?
0
 

Author Comment

by:Nakuru1234
Comment Utility
Thank you!
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and theā€¦
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now