Printable View
Is there any way to input the system date while the export writes the dump to it like I:\export\prod_08192005.dmp?
Its very tedious to daily rename the files(more than 20) and looking to automate, since i store 2 weeks of export dumps in the same storage drive.
Gurus......................
you got to write a script for that and just put the current date to a script variable and dynamically generate the parfile
Why do I even try?Quote:
Originally Posted by dbasan
Pando, is there any custom built script where i can work on it fast?
thanks for your time..........
Quote:
Originally Posted by marist89
when you are asked to do.........?
When no choice...........!!
Since your server appears to be Windows,Quote:
Originally Posted by dbasan
try using WinBatch to create the parfile and execute the export.
Because you care! ;)Quote:
Originally Posted by marist89
I think u r looking for this kinda script.......
@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
pause
Quote:
Originally Posted by pareshg
Pareshg, I hope this is what i am looking for and to make myself clear:
can i create the batch file with the above script to get the required file name with sysdate.
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.Quote:
Originally Posted by pareshg
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.