OraFAQ Forum: Forms » Export Data Base

Home » Developer & Programmer » Forms » Export Data Base

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

Export Data Base [message #295414]

Tue, 22 January 2008 05:12

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

Report message to a moderator

Re: Export Data Base [message #295438 is a reply to message #295414]

Tue, 22 January 2008 05:51

Littlefoot
Messages: 21823
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

Report message to a moderator

Re: Export Data Base [message #295447 is a reply to message #295438]

Tue, 22 January 2008 06:20

vjay
Messages: 16
Registered: December 2007
Location: chennai

Junior Member

ThanQ

Report message to a moderator

Previous Topic:	Difference between dates in years, months, days
Next Topic:	Out of Memory error on web.show_document

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 10 19:27:13 CDT 2025