Import Error: Duplicate Column names
607468Dec 18 2008 — edited Dec 23 2008Hey Everyone
I just started using SQL Developer last week (another brilliant product btw - Love it - well done). I'm wanting to use it to get around the 32K limitation on data imports in ApEx, and it looks like it'll fit the bill nicely :)
I've been using the standard GUI interface for importing data into my dbase and am having issues with the script this generates in the background to load my data. It seems to be duplicating the a column name in my database when it generates an insert statement. I've tried it several times now and am absolutely certain that I've followed the GUI correctly and liined all the columns in my source file up with the columns in my dbase.
I've noticed this occurs when there's a column missing in the source file that is present (nullable) in my destination dbase. I've then inserted that column in my source file with some random data in it and still no dice.
Is anyone able to advise of a workaround? Theres big points in it for someone lol :)
Dave