1 Reply Latest reply on Feb 3, 2016 3:23 PM by thatJeffSmith-Oracle

    Import Data... Wizard creates SQL Loader ctl file with columns out of order

    Derrick Roberts

      Version 4.1.1.19 of SQL Developer. Connected to Oracle XE for testing this.

       

      I am trying to figure out what's wrong with the data in my import file when I finally realize that the Import Data wizard did not care how I mapped the columns at all. The SQL Loader ctl file generated from the wizard expects the data columns in my file to match the order they appear in the table definition and not how they were mapped in the wizard. Manually editing the ctl file is a workaround. Has anyone else seen this?