OraFAQ Forum: Windows » Daily export by Date

Home » Infrastructure » Windows » Daily export by Date (Oracle 9i R2 windows XP sp2)

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

Daily export by Date [message #341323]

Mon, 18 August 2008 06:47

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

Report message to a moderator

Re: Daily export by Date [message #341327 is a reply to message #341323]

Mon, 18 August 2008 06:54

Michel Cadot
Messages: 68748
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Daily export by Date [message #341330 is a reply to message #341323]

Mon, 18 August 2008 06:57

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

Report message to a moderator

Re: Daily export by Date [message #341345 is a reply to message #341330]

Mon, 18 August 2008 07:38

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

Report message to a moderator

Re: Daily export by Date [message #341750 is a reply to message #341345]

Wed, 20 August 2008 03:09

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 >

Report message to a moderator

Re: Daily export by Date [message #341753 is a reply to message #341750]

Wed, 20 August 2008 03:32

Michel Cadot
Messages: 68748
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Mar 11 06:50:42 CDT 2025