OraFAQ Forum: Enterprise Manager » Scheduling Export database

Home » RDBMS Server » Enterprise Manager » Scheduling Export database (Oracle 10g, Windows 7)

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

Scheduling Export database [message #561800]

Wed, 25 July 2012 06:26

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.

Report message to a moderator

Re: Scheduling Export database [message #561801 is a reply to message #561800]

Wed, 25 July 2012 06:27

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

Report message to a moderator

Re: Scheduling Export database [message #561803 is a reply to message #561801]

Wed, 25 July 2012 06:32

bg1984
Messages: 21
Registered: July 2012

Junior Member

Thanks for your reply.
Ok, so how can we do this using 'Windows' Task Scheduler please?

Report message to a moderator

Re: Scheduling Export database [message #561804 is a reply to message #561803]

Wed, 25 July 2012 06:36

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

Report message to a moderator

Re: Scheduling Export database [message #561809 is a reply to message #561804]

Wed, 25 July 2012 06:41

bg1984
Messages: 21
Registered: July 2012

Junior Member

It is simple indeed. I appreciate your help. Thank you very much.

Report message to a moderator

Previous Topic:	RAC monitoring through 12c grid control
Next Topic:	Database Control in 11g not starting

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 16:43:03 CST 2024