OraFAQ Forum: Unix » Shell Script Directory Listing

Home » Infrastructure » Unix » Shell Script Directory Listing

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

Shell Script Directory Listing [message #243280]

Wed, 06 June 2007 13:42

Krishna_dev
Messages: 32
Registered: May 2007

Member

Hello...

I am trying to dynamically create a control file within a shell script to load data files using sql loader. control file is being created. problem comes when searching folder for data files. all data files have extension .dat. for recursively scanning directory im using the following:

for V_DATA_FILE IN 'ls -1 $V_DATA_DIR'
do

but this is not working. intention is to load all the files in the directory using control file. does anyone know how to do this.

Report message to a moderator

Re: Shell Script Directory Listing [message #243284 is a reply to message #243280]

Wed, 06 June 2007 14:28

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>this is not working
Your problem statement is not working.
My car is not working.
Please tell me how to make my car go.
Alternatively, you might be able to use the "find" command.

Report message to a moderator

Re: Shell Script Directory Listing [message #243318 is a reply to message #243284]

Wed, 06 June 2007 19:38

andrew again
Messages: 2577
Registered: March 2000

Senior Member

http://www.csee.umbc.edu/help/oracle8/server.815/a67792/ch05.htm#1528

it's not clear to me if wildcards work or not - but you can load 1 at a time...

$ sqlldr / t data=`ls -tr PDNL*.dat | tail -1`

Report message to a moderator

Previous Topic:	ORA-01033: ORACLE initialization or shutdown in progress
Next Topic:	error when executing a shell script(which contains oracle express commands) present on remote server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 10:30:06 CDT 2025