-
export dump
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......................
"What is past is PROLOGUE"
-
you got to write a script for that and just put the current date to a script variable and dynamically generate the parfile
-
Originally Posted by dbasan
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.
Why do I even try?
Jeff Hunter
-
Pando, is there any custom built script where i can work on it fast?
thanks for your time..........
"What is past is PROLOGUE"
-
Originally Posted by marist89
Why do I even try?
when you are asked to do.........?
When no choice...........!!
"What is past is PROLOGUE"
-
Originally Posted by dbasan
Pando, is there any custom built script where i can work on it fast?
thanks for your time..........
Since your server appears to be Windows,
try using WinBatch to create the parfile and execute the export.
-
Originally Posted by marist89
Why do I even try?
Because you care!
-
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
-
Originally Posted by pareshg
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
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.
"What is past is PROLOGUE"
-
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
============================================
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|