Daily export by Date [message #341323] |
Mon, 18 August 2008 06:47 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #341330 is a reply to message #341323] |
Mon, 18 August 2008 06:57 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #341750 is a reply to message #341345] |
Wed, 20 August 2008 03:09 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68653 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
|
|
|