OraFAQ Forum: Unix » Batch file....

Home » Infrastructure » Unix » Batch file....

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

Batch file.... [message #185544]

Wed, 02 August 2006 04:34

sunidhi
Messages: 36
Registered: January 2006
Location: New Delhi

Member

Hi all,

Hope doing well.

I m using ORacle 7.3 on HP-UX (10.3) Platform.

I want to run batch file from Windows to get specific file from specific directory.

How can I do that ?

Please Help me !

regards

Sunidhi

Report message to a moderator

Re: Batch file.... [message #185545 is a reply to message #185544]

Wed, 02 August 2006 05:07

vivekpatil
Messages: 3
Registered: April 2006
Location: mumbai

Junior Member

Hi,
1> Create one batch file with following text:

sqlplusw scott/tiger@server @c:\abc.txt

2> In C:\ create file abc.txt with following text :

set serveroutput on
spool c:\abcoutput.txt
select * from emp;
/
spool off
exit

save it.

3> Now run the batch file & check the output file c:\abcoutput.txt

Regards,

Vivek.

Report message to a moderator

Re: Batch file.... [message #185566 is a reply to message #185545]

Wed, 02 August 2006 06:31

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

Senior Member
Account Moderator

>>Windows to get specific file from specific directory.
If this is to do something with OS level file transfer,
look into ftp/sftp/scp concepts.

Report message to a moderator

Previous Topic:	FTP a file through UNIX script.--URGENT
Next Topic:	Craete Mainframe GDG with RECL = 1460 thru UNIX

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 18:01:10 CST 2024