Home » RDBMS Server » Enterprise Manager » Scheduling Export database (Oracle 10g, Windows 7)
Scheduling Export database [message #561800] Wed, 25 July 2012 06:26 Go to next message
bg1984
Messages: 21
Registered: July 2012
Junior Member
Hi,
I would like to export my whole database every evening. How can I do this using enterprise manager. Please help.
Re: Scheduling Export database [message #561801 is a reply to message #561800] Wed, 25 July 2012 06:27 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I don't know about EM, but - I know that it is a simple task to do that using Windows' Task Scheduler.
Re: Scheduling Export database [message #561803 is a reply to message #561801] Wed, 25 July 2012 06:32 Go to previous messageGo to next message
bg1984
Messages: 21
Registered: July 2012
Junior Member
Thanks for your reply.
Ok, so how can we do this using 'Windows' Task Scheduler please?
Re: Scheduling Export database [message #561804 is a reply to message #561803] Wed, 25 July 2012 06:36 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'd create a batch script which contains EXPDP command. Let's call it MY_EXPORT.BAT and suppose it is located in C disk's root directory.

Then, start Task Scheduler. In its upper right corner you'll see "Actions" - one of them is "Create Basic Task ...". Follow the wizard. Once you reach the "Action", choose "Start a program". Browse to the previously created C:\MY_EXPORT.BAT and that should be all.
Re: Scheduling Export database [message #561809 is a reply to message #561804] Wed, 25 July 2012 06:41 Go to previous message
bg1984
Messages: 21
Registered: July 2012
Junior Member
It is simple indeed. I appreciate your help. Thank you very much.
Previous Topic: RAC monitoring through 12c grid control
Next Topic: Database Control in 11g not starting
Goto Forum:
  


Current Time: Thu Mar 28 07:36:08 CDT 2024