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

Hi,

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

TIA,
N.
Nakuru1234Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Walter RitzelSenior Software EngineerCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Walter RitzelSenior Software EngineerCommented:
0
Nakuru1234Author Commented:
Hi,

Your answer is straight from the internet website...

TIA,
N.
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Walter RitzelSenior Software EngineerCommented:
Yes, it is because your problem is a documented one. Did you check to see if this solves your issue?
0
awking00Information Technology SpecialistCommented:
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
Nakuru1234Author Commented:
It is occuring when doing an insert from another table. I was using a select statement.

TIA,
N.
0
awking00Information Technology SpecialistCommented:
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
Walter RitzelSenior Software EngineerCommented:
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
Nakuru1234Author Commented:
I used exp / imp to go around the problem and that worked ok. Thank you for your help!

TIA,
N
0
awking00Information Technology SpecialistCommented:
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
Nakuru1234Author Commented:
Thank you!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.