Home » RDBMS Server » Server Utilities » INFILE path of SQL LOADER (10G)
icon7.gif  INFILE path of SQL LOADER [message #397635] Mon, 13 April 2009 01:55 Go to next message
venson
Messages: 7
Registered: April 2009
Location: India
Junior Member
Friends,
Can anyone help me out in this. I need to determine the datafile directory through an simple SQL statement from DBA_DIRECTORIES table (SELECT directory_path from DBA_DIRECTORIES) inside the control file of my SQL LOADER..!!! Does any one know how to achieve this...!!

Thanks in advance,
venson.
Re: INFILE path of SQL LOADER [message #397638 is a reply to message #397635] Mon, 13 April 2009 02:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't do it in SQL*Loader.
You can do it in shell from the output of a SQL*Plus script.

Regards
Michel
icon7.gif  Re: INFILE path of SQL LOADER [message #397640 is a reply to message #397638] Mon, 13 April 2009 02:19 Go to previous messageGo to next message
venson
Messages: 7
Registered: April 2009
Location: India
Junior Member
Sorry for not giving the exact requirement. Sorry I am new to SQL LOADER..!!!
There is already a well defined control file available for my SQL LOADER where i need to do some modification on the control file in such a way that it would get the INFILE path from DBA_DIRECTORIES table. Can we do that..???!
Re: INFILE path of SQL LOADER [message #397648 is a reply to message #397640] Mon, 13 April 2009 02:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
You can't do it in SQL*Loader.
You can do it in shell from the output of a SQL*Plus script.

Regards
Michel
icon7.gif  Re: INFILE path of SQL LOADER [message #397657 is a reply to message #397648] Mon, 13 April 2009 03:16 Go to previous messageGo to next message
venson
Messages: 7
Registered: April 2009
Location: India
Junior Member
Michel, Thanks a lot for your reply. Do you mean...that i should write a Wrapper in Shell which would inturn call SQL-LOADER and pass on the o/p of SQL SELECT statement agaist DBA_Directories. Could you help me in refering some examples pls.

Thanks in advance.
Re: INFILE path of SQL LOADER [message #397660 is a reply to message #397657] Mon, 13 April 2009 03:22 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes this is what I meant.
There are many scripts in this forum and in Unix and Windows ones depending on your OS.

Regards
Michel
Previous Topic: IMPDP with DB_LINK and different OS
Next Topic: impdp error
Goto Forum:
  


Current Time: Fri Dec 09 06:15:50 CST 2016

Total time taken to generate the page: 0.10716 seconds