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
unable to insert the records in oracle table
Moderators: chulett, rschirm, roy
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.
Mark Winter
<i>Nothing appeases a troubled mind more than <b>good</b> music</i>
<i>Nothing appeases a troubled mind more than <b>good</b> music</i>