I am using sql loader to deliver some files to my client. I LOVE that you can use sql developer's export feature to create the LDR and CTL files (type: loader in the export wizard). However, it embeds the file name like this
in the control file. If I manually remove C:\DEVTOP\PROJ1\, they work great in any directory.
Since I have many tables though, I'd love to know if there is a way to have sql developer generate my CTL files without sticking the whole path in there like that...