Home » Infrastructure » Windows » Daily export by Date (Oracle 9i R2 windows XP sp2)
Daily export by Date [message #341323] Mon, 18 August 2008 06:47 Go to next message
savlon99
Messages: 22
Registered: June 2008
Location: Bangladesh
Junior Member
Hi all
I want to create a batch file for oracle daily export.There i want to mention daily time and exporting time .
Please correct my batch file which i mention below..


sqlplus /nolog @start.sql

exp airtel/airtel@student file='C:\full%date%.dmp' full=y log='C:\log_full%date%.log'

sqlplus /nolog @check.sql



Thanks
sav
Re: Daily export by Date [message #341327 is a reply to message #341323] Mon, 18 August 2008 06:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What happen when you did it?

By the way, you can search here in the Windows forum, this has been asked and answered several times.

Regards
Michel
Re: Daily export by Date [message #341330 is a reply to message #341323] Mon, 18 August 2008 06:57 Go to previous messageGo to next message
savlon99
Messages: 22
Registered: June 2008
Location: Bangladesh
Junior Member
Thanks Michel for your quick reply .
Dear when i start this batch file it will be ask the file name of export .



Export: Release 9.2.0.1.0 - Production on Mon Aug 18 17:55:44 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
EXP-00028: failed to open C:\fullMon 08/18/2008.dmp for write
Export file: EXPDAT.DMP >



Thanks
Sav
Re: Daily export by Date [message #341345 is a reply to message #341330] Mon, 18 August 2008 07:38 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Hello,

Try this one.

exp usrname/pwd@dbname full=y file=%date:~-4%_%date:~-2%_%date:~-2%.dmp  
log=C:\log_full_%date:~-4%_%date:~-2%_%date:~-2%.log


Babu
Re: Daily export by Date [message #341750 is a reply to message #341345] Wed, 20 August 2008 03:09 Go to previous messageGo to next message
savlon99
Messages: 22
Registered: June 2008
Location: Bangladesh
Junior Member

C:\Documents and Settings\InGen\Desktop>exp airtel/airtel@student full=y file=8/
08_08_08.dmp

Export: Release 9.2.0.1.0 - Production on Wed Aug 20 14:07:41 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
EXP-00028: failed to open 8/08_08_08.dmp for write
Export file: EXPDAT.DMP >







Re: Daily export by Date [message #341753 is a reply to message #341750] Wed, 20 August 2008 03:32 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Your problem is NOT an Oracle one, just a windows one, check in Windows forum for the solution, this topic is now locked.

Regards
Michel
Previous Topic: Oracle Installation on Windows XP Pro 64bit
Next Topic: How To Install Jinitiator ( oajint ) on 64 bit Windows XP
Goto Forum:
  


Current Time: Thu Mar 28 13:25:00 CDT 2024