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
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
ASKER
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry i have to research this a little further.
ASKER
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?
Any Ideas?
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.
I'm not sure what else I could add to it.
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?