Nakuru1234
asked on
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.
What advice can you give me about this error message?: "ORA-14400: Inserted partition key does not map to any partition."
TIA,
N.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Yes, it is because your problem is a documented one. Did you check to see if this solves your issue?
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?
ASKER
It is occuring when doing an insert from another table. I was using a select statement.
TIA,
N.
TIA,
N.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I used exp / imp to go around the problem and that worked ok. Thank you for your help!
TIA,
N
TIA,
N
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?
ASKER
Thank you!
ASKER
Your answer is straight from the internet website...
TIA,
N.