Forum Stats

  • 3,836,746 Users
  • 2,262,177 Discussions


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

Derrick Roberts
Derrick Roberts Member Posts: 11
edited Feb 3, 2016 10:23AM in SQL Developer

Version 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?


Best Answer


This discussion has been closed.