Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Random Data Loading Column Mapping Issue

850667Feb 7 2013
Let's say that I have set up a data loading wizard which maps to a table with six columns A B C D E F. It seems that I should be able to load a CSV with only some of the columns like A B C, even if the CSV has some unrelated columns X Y Z. I also had column E in the CSV, even though it was NULL.

So I go through the steps and after specifying the file name on the first step I click next, and the CSV columns A B C E automatically map to database columns A B C E, and the extraneous columns X Y X properly show "Do Not Load". I complete the steps and then look at the table, and A B C loaded correctly, but now the former contents of column Y are showing up in column E. Is this a known bug?

Using Application Express Version 4.1.1.00.23.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 7 2013
Added on Feb 7 2013
0 comments
184 views