OraFAQ Forum: Server Utilities » expdp in windows batch file

Home » RDBMS Server » Server Utilities » expdp in windows batch file (Oracle 11g R2 - Windows Server 2008 R2 Enterprise)

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

expdp in windows batch file [message #658036]

Thu, 01 December 2016 03:19

ashussain
Messages: 35
Registered: March 2011
Location: Saudi Arabia

Member

Hi,

Need your help to run a batch file under windows for expdp in Windows Server 2008 R2 Enterprise Edition, Oracle 11gR2.

My batch file: dumpfile.bat contains....

del *.old
ren *.log *.log.old
ren *.DMP *.DMP.old
expdp system/***** DUMPFILE=DUMP_DIR:schname_%u.dmp LOGFILE=DUMP_DIR:schlog.log SCHEMAS=schemaname PARALLEL=4

This batch file is generating a single file as shcnameschlog.LOG which seems to be a single dump file. But if I run the above expdp command directly under DOS, it is running fine and generating four dump files like schname_01.DMP, schname_02.DMP, schname_03.DMP and schname_04.DMP.

Please let me know, where am I going wrong.

Thanks in Advance.

Regards,
Aijaz S Hussain

Report message to a moderator

[Message index]

		expdp in windows batch file By: ashussain on Thu, 01 December 2016 03:19
		Re: expdp in windows batch file By: John Watson on Thu, 01 December 2016 03:48
		Re: expdp in windows batch file By: ashussain on Thu, 01 December 2016 04:42

Previous Topic:	Message 2100???
Next Topic:	sqlldr WHEN clause using <=

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 17:13:30 CDT 2024