• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 655
  • Last Modified:

SQL Developer Loader Export Without Path Name On INFILE

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...
Jay Redd
Jay Redd
  • 2
1 Solution
DavidSenior Oracle Database AdministratorCommented:
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/
Jay ReddAuthor Commented:
It's not absent, I WANT it to be absent. I want to avoid manual editing, not add more manual editing.
DavidSenior Oracle Database AdministratorCommented:
I understand.  Did you read through the solution example?  INFILE resolves to a variable that's defined outside of the job run.  


for fi in source1 source2; do
export INFILE_loc=$fi
$ORACLE_HOME/bin/sqlldr..... INFILE='INFILE_loc'
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now