<div>
If a parameter is absent from the control file, you should be able to specify it on the command line. &nbsp;My preference would be to set an O/S variable, load it with the desired string, and reference the variable in the control file.<br />
<br />
Syntax attached.<br />
<br />
Solution example: <a href="http://www.orafaq.com/forum/t/12234/0/" rel="ugc">http://www.orafaq.com/forum/t/12234/0/</a>
</div>


If a parameter is absent from the control file, you should be able to specify it on the command line.  My preference would be to set an O/S variable, load it with the desired string, and reference the variable in the control file.

Syntax attached.

Solution example: http://www.orafaq.com/forum/t/12234/0/ [http://www.orafaq.com/forum/t/12234/0/]

<div>
It's not absent, I WANT it to be absent. I want to avoid manual editing, not add more manual editing.
</div>


It's not absent, I WANT it to be absent. I want to avoid manual editing, not add more manual editing.

<div>
<div class="content wysiwyg-content">
Hi.<br />
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<br />
<br />
INFILE=&quot;C:\DEVTOP\PROJ1\TA<wbr />BLE1_TABLE<wbr />_DATA.LDR&quot;<wbr /><br />
<br />
in the control file. If I manually remove C:\DEVTOP\PROJ1\, they work great in any directory. <br />
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...
</div>
</div>


Hi.
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

INFILE="C:\DEVTOP\PROJ1\TABLE1_TABLE_DATA.LDR"

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...

SQL Developer Loader Export Without Path Name On INFILE

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.