Home » Developer & Programmer » Forms » Export Data Base
Export Data Base [message #295414] Tue, 22 January 2008 05:12 Go to next message
vjay
Messages: 16
Registered: December 2007
Location: chennai
Junior Member
Hi,
I am taking Data base back up using Batch file and that file assign to Schedule.so every day automatically it is executing and saving to file. That batch file contains below script.
exp pplus/computer@abcd file=e:\bkup\pplus.dmp grants=Y buffer=10000 log=e:\bkup\pplus.log.

Every day replacing that file.But i want to take everyday backup in folder.So i am giving file=e:\bkup\pplus Concatenate(||) Date .how to concatenate filename with sysdate in Dos. any Command to concatenate sysdate with filename?


-Thanks
Re: Export Data Base [message #295438 is a reply to message #295414] Tue, 22 January 2008 05:51 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Here's an example:
@echo off
setlocal
for /f "tokens=2" %%i in ("%date:/=_%") do set vdate=%%i
for /f "tokens=1,2 delims=:" %%i in ("%time: =%") do set vdate=%vdate%_%%i%%j
c:\oracle\product\10.2.0\db_1\bin\exp.exe userid=scott/tiger@orcl file=e:\syr%vdate%.dmp owner=scott
endlocal
echo on

When executed:
c:\> test.bat
c:\oracle\product\10.2.0\db_1\bin\exp.exe userid=scott/tiger@orcl file=e:\syr07_19_2006_803.dmp owner=scott
Re: Export Data Base [message #295447 is a reply to message #295438] Tue, 22 January 2008 06:20 Go to previous message
vjay
Messages: 16
Registered: December 2007
Location: chennai
Junior Member
ThanQ
Previous Topic: Difference between dates in years, months, days
Next Topic: Out of Memory error on web.show_document
Goto Forum:
  


Current Time: Sat Dec 10 22:25:44 CST 2016

Total time taken to generate the page: 0.07693 seconds