export dump

Quote:

---

Originally Posted by pareshg

Yes u can create the batch file with following code


============================================
@ECHO OFF
FOR /F "TOKENS=2-5 DELIMS=/ " %%F IN ('DATE /T') DO (
SET MM=%%F
SET DD=%%G
SET YYYY=%%H
)
SET CURDATE=%MM%%DD%%YYYY%
d:\oracle\ora817\bin\exp user/pwd@service file=d:\backup\dumps\exp_data_%CURDATE%.dmp log=d:\backup\dumps\exp_data_%CURDATE%.log
exit

============================================

---

pareshg, this is the code i executed, but it does not works. Can u check in again. when i clik the batch file it does'nt even open the command file for execution.
thanks for ur time

@ECHO OFF
FOR /F "TOKENS=2-5 DELIMS=/ " %%F IN ('DATE /T') DO (
SET MM=%%F
SET DD=%%G
SET YYYY=%%H
)
SET CURDATE=%MM%%DD%%YYYY%
D:\Oracle\Ora92\bin\exp system/[email protected] file=J:\Exports\Dev\CON\exp_con_%CURDATE%.dmp log=J:\Exports\Dev\CON\exp_con_%CURDATE%.log tables=admin.clock

Run the batch file from command prompt and check what error it throws...

Check if file and log path exists and are mapped when exporting...

Amar, thanks for the work around, I get the following errors

LRM-00112: multiple values not allowed for parameter 'log'

EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help
EXP-00000: Export terminated unsuccessfully

From the error it shows that it is not accepting the CURDATE variable given in the log parameter, iam also curious that why it did not reflect for the file parameter?

Any other way to execute the file.