OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » dynamic infile

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

dynamic infile [message #120116]

Tue, 17 May 2005 17:10

whited05
Messages: 10
Registered: May 2005
Location: Lansdale, PA

Junior Member

Hello all I have a sqlldr ctl file that I need to be able to dynamically create the file name based on the date.

i.e. infile 'order_inventory_200505.dat'

In the file example I need to append 200505 to the 'order_inventory.dat

is there a way to do this? can I use a shell variable?

Thanks,
dan Cool

Report message to a moderator

Re: dynamic infile [message #120138 is a reply to message #120116]

Tue, 17 May 2005 21:49

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

I dont understand the requirement.
Your filename is order_inventory.dat.
Do you want to change the name to order_inventory_200505.dat and load it?

Report message to a moderator

Re: dynamic infile [message #120187 is a reply to message #120138]

Wed, 18 May 2005 06:00

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

HI

Wats the OS u r using?

If UNIX use:
date +%Y%m for generating the reuired date format.

If windows use DOS date format utility "doff". U may need to download this.

Geberate the date in desired format and append the .dat file name with this date format.
I hope that'll solve the issue..

Report message to a moderator

Previous Topic:	sqlldr data issue
Next Topic:	Import failed from 9.2 to 8.1.7 ( URGENT )

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 07:52:55 CDT 2024