OraFAQ Forum: Server Utilities » INFILE path of SQL LOADER

Home » RDBMS Server » Server Utilities » INFILE path of SQL LOADER (10G)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

INFILE path of SQL LOADER [message #397635]

Mon, 13 April 2009 01:55

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.

Report message to a moderator

Re: INFILE path of SQL LOADER [message #397638 is a reply to message #397635]

Mon, 13 April 2009 02:12

Michel Cadot
Messages: 68645
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

Report message to a moderator

Re: INFILE path of SQL LOADER [message #397640 is a reply to message #397638]

Mon, 13 April 2009 02:19

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..???!

Report message to a moderator

Re: INFILE path of SQL LOADER [message #397648 is a reply to message #397640]

Mon, 13 April 2009 02:47

Michel Cadot
Messages: 68645
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

Report message to a moderator

Re: INFILE path of SQL LOADER [message #397657 is a reply to message #397648]

Mon, 13 April 2009 03:16

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.

Report message to a moderator

Re: INFILE path of SQL LOADER [message #397660 is a reply to message #397657]

Mon, 13 April 2009 03:22

Michel Cadot
Messages: 68645
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

Report message to a moderator

Previous Topic:	IMPDP with DB_LINK and different OS
Next Topic:	impdp error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 02:06:32 CDT 2024