• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 494
  • Last Modified:

Step by Step Oracle scheduled export job

I'm a novice with Oracle, I just just started as a result of being thown in a position of supporting Oracle databases with no knowledge.  I need to learn how to create a scheduled job that takes a nightly export of a database and saves it to a specified location.

I need to take daily exports for the days of the week.

sorry but I would really appreciate step by step instructions considering my lack of knowledge.  

also if you know of good loinks where I could find additional information to assist.

Please provide step by step instructions for:
   Creating the oracle job
   Scheduling the job to export
  • 3
  • 3
1 Solution
slightwv (䄆 Netminder) Commented:
What Oracle version?
Were you directed to use classic exp/imp or the new datapump (expdp/impdp)?
What OS?
Were you told to use a certain type of scripting/job?

You are also aware that export/imp really isn't considered a backup strategy.

>>I need to take daily exports for the days of the week.

Does this mean a weeks worth of data?
Steve7423Author Commented:
Version 10g

I was directed to use classic export (exp)

the oerating system is windows 2003

the situation is, there's an existing fellow who normally does this but isn't around much and no one knows what he does, including me.  I have to create a scheduled job that exports the database on a daily basis.  yes I understand about the backup strategy, we also have archiving in place as well.

I wasn't told to use any scripting type.  

The database will be exported to a folder with subfolders for each day of the week; Monday tuesday ....so on.

I understand I could create a job through Enterprise Manager but I don't know how to install that and get it set up either.

I would like to learn from a step by step script that creates a scheduled job which then exports the database to a specified folder based on the particular day.  Eg: if today is monday the job should export the database to the Monday folder, then on tuesday it exports the database to the Tuesday folder...and so on.  the job needs to run at a time like 12 am or something, the time is irrelevent.

If my logic is incorrect i welcome advice.  I'm trying to learn how to do this, a script with comments explaining what's going on is how I learn best.  

If I can do this through EM please explain how I can get EM working.
slightwv (䄆 Netminder) Commented:
I then suggest you use BAT scripting.  

There are many exmaples out there on using date pieces with file names for Oracle exports.

I would start with one of those then tweak it to your specific requirements.

Unfortunately, writing complete code based on specific requirements is a little outside the scope of a Q&A site like this.  Some Experts might be willing to write the code for you but ou would need to ask the question in the appropriate zone for the scripting language you choose to use.

Here is script found with a quick Google that adds dates/times to export files:
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Steve7423Author Commented:
Sorry i have to research this a little further.
Steve7423Author Commented:
I'm a real newbie to Oracle and I require detailed step by step assistance with this.  If anyone could offer step by step instructions it would be appreciated.

Any Ideas?
slightwv (䄆 Netminder) Commented:
What part of the script in the link I provided does not work for you?

I'm not sure what else I could add to it.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now