unable to insert the records in oracle table

prams · Post by **prams** » Fri Jan 23, 2009 3:55 am

Hi
i am inserting into oracle table through datastage job but the job getting aboring due to this fatal error
the error message is like this.
"esql complaint: ORA-14400: inserted partition key does not map to any partition"

can any one help me in this regard, how to proced further steps to take to get into insert the records.

Thanks in Advance

Prams

miwinter · Post by **miwinter** » Fri Jan 23, 2009 3:59 am

I'd suspect you are using 'Oracle' as the partitioning type on the target stage and the data going into the table, in respect of the partitioning keys defined on that table, don't add up somehow. Consult your Oracle DBA to find out what the table is partitioned on and see if you can find any erroneous looking data on the input, specifically on those attributes.

miwinter · Post by **miwinter** » Fri Jan 23, 2009 4:11 am

PS. This was posted under server, whereas it's an EE job

gnan_gun · Post by **gnan_gun** » Tue Jan 27, 2009 2:50 am

Hi,

Whatever data u r inserting into that target table is not matching with your table partition condition. Please go through your table creation DDL command or u can view in SQL Navigator --> ur server -->ur schema -->Tables -->choose ur table -->Table Partitions.